
STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
HPRD1         1135440730 HPRD1               1 9.2.0.8.0   NO      vhpud11

              Snap Id     Snap Time      Sessions Curs/Sess Comment
            --------- ------------------ -------- --------- -------------------
Begin Snap:     46923 11-Sep-09 07:18:48       54       8.3
  End Snap:     46994 11-Sep-09 19:09:02       17       4.2
   Elapsed:              710.23 (mins)

Cache Sizes (end)
~~~~~~~~~~~~~~~~~
               Buffer Cache:    10,240M      Std Block Size:          8K
           Shared Pool Size:     3,200M          Log Buffer:      2,304K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:            476,303.68             53,803.92
              Logical reads:            190,378.64             21,505.43
              Block changes:              4,672.89                527.86
             Physical reads:              7,869.76                888.98
            Physical writes:                471.60                 53.27
                 User calls:              4,367.66                493.38
                     Parses:                804.86                 90.92
                Hard parses:                 18.35                  2.07
                      Sorts:                403.76                 45.61
                     Logons:                  1.30                  0.15
                   Executes:              1,692.17                191.15
               Transactions:                  8.85

  % Blocks changed per Read:    2.45    Recursive Call %:     31.85
 Rollback per transaction %:    0.06       Rows per Sort:    284.24

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:   99.99       Redo NoWait %:    100.00
            Buffer  Hit   %:   96.21    In-memory Sort %:    100.00
            Library Hit   %:   99.32        Soft Parse %:     97.72
         Execute to Parse %:   52.44         Latch Hit %:     99.86
Parse CPU to Parse Elapsd %:   39.74     % Non-Parse CPU:     98.55

 Shared Pool Statistics        Begin   End
                               ------  ------
             Memory Usage %:   17.99   58.87
    % SQL with executions>1:    9.13   70.89
  % Memory for SQL w/exec>1:   10.42   64.31

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file sequential read                       193,696,645     205,605    50.37
CPU time                                                      184,433    45.18
db file scattered read                         14,279,468       3,891      .95
db file parallel write                            644,584       3,019      .74
enqueue                                             3,307       2,841      .70
          -------------------------------------------------------------
Wait Events for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read       193,696,645          0    205,605      1    513.5
db file scattered read         14,279,468          0      3,891      0     37.9
db file parallel write            644,584          0      3,019      5      1.7
enqueue                             3,307        948      2,841    859      0.0
PL/SQL lock timer                      37         37      2,168  58594      0.0
log file sync                     335,670          6      2,103      6      0.9
buffer busy waits               1,107,809          9      1,636      1      2.9
db file parallel read             141,337          0        652      5      0.4
async disk IO                      98,712          0        465      5      0.3
latch free                         59,750     26,528        310      5      0.2
SQL*Net more data to client    15,093,214          0        281      0     40.0
direct path write                 122,239          0        159      1      0.3
log file sequential read          103,803          0        121      1      0.3
direct path read                  359,232          0        108      0      1.0
PX Deq: Execute Reply              59,977          7         74      1      0.2
log file parallel write           527,953          0         66      0      1.4
log buffer space                    1,367          0         47     35      0.0
library cache pin                   1,689          0         39     23      0.0
control file parallel write        21,157          0         36      2      0.1
PX Deq Credit: send blkd           71,633          0         34      0      0.2
single-task message                   190          0         17     90      0.0
row cache lock                      4,911          0         15      3      0.0
log file switch completion            637          0         13     20      0.0
SQL*Net message from dblink         6,048          0          9      1      0.0
write complete waits                    8          8          8    977      0.0
process startup                       194          0          6     33      0.0
library cache lock                     18          0          5    297      0.0
local write wait                      159          3          5     32      0.0
control file sequential read      385,012          0          4      0      1.0
LGWR wait for redo copy            12,229         18          2      0      0.0
PX Deq Credit: need buffer          9,255          0          2      0      0.0
log file single write                 512          0          1      2      0.0
PX Deq: Table Q qref               48,457          0          1      0      0.1
PX Deq: Parse Reply                 1,698          0          1      0      0.0
PX Deq: Table Q Sample                325          0          0      2      0.0
SQL*Net break/reset to clien          986          0          0      0      0.0
SQL*Net more data from dblin        4,053          0          0      0      0.0
db file single write                  288          0          0      1      0.0
PX Deq: Join ACK                    1,734          0          0      0      0.0
PX Deq: Table Q Get Keys              281          0          0      1      0.0
undo segment extension             25,143     25,103          0      0      0.1
PX Deq: Msg Fragment                  787          0          0      0      0.0
PX Deq: Signal ACK                  2,442        357          0      0      0.0
SQL*Net more data to dblink         4,944          0          0      0      0.0
kksfbc child completion                 8          6          0      7      0.0
library cache load lock                 2          0          0     17      0.0
SQL*Net message to dblink           6,048          0          0      0      0.0
buffer deadlock                        27         27          0      0      0.0
SQL*Net message from client   186,517,123          0 ##########    126    494.4
Wait Events for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> s  - second
-> cs - centisecond -     100th of a second
-> ms - millisecond -    1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------ ---------- ---------- ------ --------
jobq slave wait                     3,904      3,852     11,386   2916      0.0
PX Idle Wait                        4,338      1,660      3,625    836      0.0
PX Deq: Execution Msg              76,247         54        331      4      0.2
SQL*Net more data from clien    1,545,042          0        161      0      4.1
SQL*Net message to client     186,517,102          0        150      0    494.4
PX Deq: Table Q Normal             18,033          0         27      1      0.0
          -------------------------------------------------------------
Background Wait Events for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> ordered by wait time desc, waits desc (idle events last)

                                                                   Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file parallel write            644,583          0      3,019      5      1.7
async disk IO                      97,024          0        455      5      0.3
log file sequential read           33,536          0        118      4      0.1
log file parallel write           527,950          0         66      0      1.4
control file parallel write        20,581          0         35      2      0.1
direct path read                   56,018          0         10      0      0.1
db file sequential read             4,135          0          7      2      0.0
log buffer space                      514          0          6     11      0.0
enqueue                                 3          1          3   1120      0.0
direct path write                  18,400          0          2      0      0.0
rdbms ipc reply                     1,420          0          2      1      0.0
LGWR wait for redo copy            12,228         18          2      0      0.0
buffer busy waits                     268          1          2      7      0.0
log file single write                 512          0          1      2      0.0
latch free                            683         13          1      1      0.0
control file sequential read       29,565          0          1      0      0.1
db file scattered read                177          0          0      0      0.0
rdbms ipc message               1,918,356     38,379    232,839    121      5.1
pmon timer                         14,194     14,194     41,583   2930      0.0
smon timer                         51,474          0     41,443    805      0.1
          -------------------------------------------------------------
SQL ordered by Gets for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Buffer Gets Threshold:     10000
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed 100

                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
    822,467,944            1  822,467,944.0   10.1  8066.63   8995.89 2547579270
Module: SQL*Plus
DECLARE    u NUMBER; BEGIN u := Hisq_Ism.DemarrerConsolidateur('
0','1'); END;

    691,996,561           37   18,702,609.8    8.5  6529.77   6639.87  373117231
Module: HISTO
INSERT /*+ append nologging */ INTO HISO_TEMP_LOG ( RANG ,CONSOL
IDATION_FICHIER_OID ,COMMITED_TRANS_OID ,TABLE_NAME ,OBJET_METIE
R_OID ,ETAT_OBJET ,ROW_ID ,XID ,SCN ,CSCN ,ROLLBACK ,OPERATION ,
OPERATION_CODE ,SEG_TYPE ,SEG_TYPE_NAME ,SEG_NAME ,SEG_OWNER ,US
ERNAME ,TIMESTAMP ,SQL_UNDO ,SQL_REDO ) SELECT /*+ ORDERED full(

    683,873,840    3,886,393          176.0    8.4  4250.12   4291.99  945954842
DECLARE  p1 NUMBER := :1;  p2 NUMBER := :2;  p3 NUMBER := :3;  p
4 NUMBER;  p5 NUMBER;  p6 NUMBER;  p7 NUMBER;  p8 NUMBER;  p9 NU
MBER;  p10 NUMBER;  p11 NUMBER;  p12 VARCHAR2(31);  p13 VARCHAR2
(31);  p14 VARCHAR2(31);  p15 VARCHAR2(31);  p16 NUMBER;  p17 NU
MBER;  p18 VARCHAR2(31);  p19 NUMBER;  BEGIN       SYS.LOGMNR_GT

    643,955,164      285,306        2,257.1    7.9  3302.60   3364.72 3220955576
SELECT BO.SPARE2,TP.BO#,T.INTCOLS,TP.TS#,TS.NAME,T.PROPERTY   FR
OM SYS.TABPART$ TP,SYS.TS$ TS,SYS.OBJ$ BO,SYS.TAB$ T  WHERE TP.O
BJ# = :b1  AND BO.OBJ# = TP.BO#  AND T.OBJ# = TP.BO#  AND TS.TS#
 = TP.TS#

    607,135,105       57,960       10,475.1    7.5 ########  38360.44 2265335941
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
begin VPRS_XML.GenericProcedure(pProcedureName=>:pProcedureName,
 pXMLInputParam=>:pXMLInputParam, pXMLOutputParam=>:pXMLOutputPa
ram); end;

    453,863,183          706      642,865.7    5.6  5082.28  12121.91  259613574
Module: sqr@vhpue12 (TNS V1-V3)
SELECT U1.NumeroCompte, U1.numero_piece, (SELECT distinct gcp.ty
pe_piece_pic FROM GCPT_COMPTE_PIECE gcp WHERE gcp.POSTE_COMPTABL
E_OID = :1 and gcp.PIECE_OID = U1.PIECE_OID and rownum = 1), (SE
LECT TO_CHAR(MIN(gcp.DATE_CREATION), 'DD/MM/YYYY') from gcpt_com
pte_piece gcp where gcp.piece_oid = U1.PIECE_OID and gcp.Poste_C

    285,539,893       29,138        9,799.6    3.5 ########  18073.29 2429394239
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
BEGIN TIE_RAPPROCHER_TIERS.GenericProcedure(:a,:b,:c); END;

    192,893,169      107,109        1,800.9    2.4   653.92   1448.98 3336519982
Module: /app/apphls/forte/userapp/sr1_bann/cl0/sr1_ba5@v
select T3.TYPE_ELEMENT_OID, count (distinct(T3.OID)) from WFWO_E
LEMENT T1, WFWO_APPARTENANCE T2, WFWO_ELEMENT T3 where T3.OID =
 T1.ELEMENT_CONTENANT_OID and T1.POSTE_COMPTABLE_OID =  :var1 an
d T3.POSTE_COMPTABLE_OID = T1.POSTE_COMPTABLE_OID and T1.GROUPE_
SQL ordered by Gets for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Buffer Gets Threshold:     10000
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed 100

                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
TRAVAIL_OID = T2.GROUPE_TRAVAIL_OID and T2.UTILISATEUR_OID = :va

    159,664,911        9,093       17,559.1    2.0  1349.12   4522.65 2304888096
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.POSTE_COMPTABLE_OID, t1.
CODE_POSTE_COMPTABLE, t1.BUDGET_COLLECTIVITE_OID, t1.CODE_BUDGET
_COLLECTIVITE, t1.EXERCICE_OID, t1.CODE_EXERCICE, t1.TYPE_MESSAG
E_PIC, t1.NOM_FICHIER_ORDONNATEUR, t1.NOM_FICHIER_TRADEXPRESS, t
1.DATE_RECEPTION, t1.TYPE_ENVELOPPE_PIC, t1.IDENTIFIANT_METIER_M

    152,196,282        4,847       31,400.1    1.9  6329.85   7615.16 2954830172
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
BEGIN DEP_INTEGRATION.GenericProcedure(:a,:b,:c); END;

    108,392,665       40,358        2,685.8    1.3  7401.37   8345.38 1194005673
Module: /app/apphls/forte/userapp/sr1_barb/cl0/sr1_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.EXERCICE_OID, t1.POSTE_C
OMPTABLE_OID, t1.DATE_JOURNEE_TRESORERIE, t1.ETAT_JOURNEE_TRESOR
ERIE_PIC, t1.EST_ARCHIVE  FROM GCPT_JOURNEE_TRESORERIE t1, GCPT_
JOURNEE_COMPTABLE t2   WHERE (  ( t1.OID = t2.JOURNEE_TRESORERIE
_OID ) AND (  ( t2.EXERCICE_OID = :var1 ) AND ( t2.POSTE_COMPTAB

    108,363,670       57,652        1,879.6    1.3  5176.92   5660.91 3851911766
Module: HISTO
INSERT INTO REF_SESSIONS_BATCHS ( ID , ETAT , DATE_DEBUT , DATE_
FIN , UTILISATEUR , BTC_ID ) SELECT :B3 ,:B2 ,SYSDATE ,SYSDATE ,
USER ,A.ID FROM REF_BATCH A WHERE UPPER(A.CODE) = UPPER(:B1 )

     88,871,573       48,650        1,826.8    1.1   704.61   1024.73 3283188924
Module: /app/edt_cpt/conso_batch/conso_batch@vhpue12 (TN
select  /*+ USE_NL(b a) */  a.rowid, b.oid, b.chn, b.edt, b.typ,
 b.cmd from extr_traitement a, (select /*+ ORDERED  index(a XIE1
8EXTR_TRAITEMENT) */ a.rowid as row_id, to_char(a.oid) as oid, d
ecode(a.est_chaine, 1, '1', nvl(to_char(a.traitement_chaine_oid)
, '0')) as chn, decode(a.code_mode_edition_pic, 1, 'C', 2, 'L',

     85,716,349       17,714        4,838.9    1.1  5907.45   6515.61 1746552299
Module: Rapprocher_Tiers
BEGIN DEP_MARQUAGE.GenericProcedure(:a,:b,:c); END;

     61,527,409      105,772          581.7    0.8   843.92   2912.83 3315890492
Module: /app/apphls/forte/userapp/sr1_tech/cl0/sr1_te5@v
SELECT t1.CODE_ETAT_TRAIT_PIC , COUNT ( t1.OID )  FROM EXTR_TRAI
TEMENT t1   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1
.EXERCICE_OID = :var2 ) AND ( t1.TRAITEMENT_CHAINE_OID IS NULL )
  AND ( t1.DATE_CONSERVATION_DEMANDE > :var3 ) AND ( t1.CODE_ETA
T_TRAIT_PIC IN ( :var4, :var5, :var6, :var7 ) ) AND (  ( t1.UTIL

     46,575,571       10,669        4,365.5    0.6   368.01   1668.80 2735370824
Module: /app/apphls/forte/userapp/sr2_tech/cl0/sr2_te5@v
SQL ordered by Gets for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Buffer Gets Threshold:     10000
-> Note that resources reported for PL/SQL includes the resources used by
   all SQL statements called within the PL/SQL code.  As individual SQL
   statements are also reported, it is possible and valid for the summed
   total % to exceed 100

                                                     CPU      Elapsd
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
SELECT COUNT ( t1.OID )  FROM EXTR_TRAITEMENT t1, EXTR_TYPE_TRAI
TEMENT t2   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1
.EXERCICE_OID = :var2 ) AND ( t1.TYPE_TRAITEMENT_OID = t2.OID )
AND (  ( t2.CODE_SOUS_TYPE_TRAIT_PIC = :var3 ) ) AND ( t1.TRAITE
MENT_CHAINE_OID IS NULL )  AND ( t1.DATE_CONSERVATION_DEMANDE >

     46,542,404       10,662        4,365.3    0.6   435.14    548.06 3987933399
Module: /app/apphls/forte/userapp/sr2_tech/cl0/sr2_te5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.EXERCICE_OID
, t1.POSTE_COMPTABLE_OID, t1.BUDGET_COLLECTIVITE_OID, t1.UTILISA
TEUR_OID, t1.TYPE_TRAITEMENT_OID, t1.CHAINE_TRAITEMENT_OID, t1.T
RAITEMENT_CHAINE_OID, t1.MODELE_TYPE_TRAITEMENT_OID, t1.TRAITEME

          -------------------------------------------------------------
SQL ordered by Reads for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Disk Reads Threshold:      1000

                                                     CPU      Elapsd
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
     36,080,580       57,960          622.5   10.8 ########  38360.44 2265335941
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
begin VPRS_XML.GenericProcedure(pProcedureName=>:pProcedureName,
 pXMLInputParam=>:pXMLInputParam, pXMLOutputParam=>:pXMLOutputPa
ram); end;

     33,128,702       29,138        1,137.0    9.9 ########  18073.29 2429394239
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
BEGIN TIE_RAPPROCHER_TIERS.GenericProcedure(:a,:b,:c); END;

      6,986,942        9,093          768.4    2.1  1349.12   4522.65 2304888096
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.POSTE_COMPTABLE_OID, t1.
CODE_POSTE_COMPTABLE, t1.BUDGET_COLLECTIVITE_OID, t1.CODE_BUDGET
_COLLECTIVITE, t1.EXERCICE_OID, t1.CODE_EXERCICE, t1.TYPE_MESSAG
E_PIC, t1.NOM_FICHIER_ORDONNATEUR, t1.NOM_FICHIER_TRADEXPRESS, t
1.DATE_RECEPTION, t1.TYPE_ENVELOPPE_PIC, t1.IDENTIFIANT_METIER_M

      4,789,410          706        6,783.9    1.4  5082.28  12121.91  259613574
Module: sqr@vhpue12 (TNS V1-V3)
SELECT U1.NumeroCompte, U1.numero_piece, (SELECT distinct gcp.ty
pe_piece_pic FROM GCPT_COMPTE_PIECE gcp WHERE gcp.POSTE_COMPTABL
E_OID = :1 and gcp.PIECE_OID = U1.PIECE_OID and rownum = 1), (SE
LECT TO_CHAR(MIN(gcp.DATE_CREATION), 'DD/MM/YYYY') from gcpt_com
pte_piece gcp where gcp.piece_oid = U1.PIECE_OID and gcp.Poste_C

      4,420,142          139       31,799.6    1.3   207.86    349.43 2054756809
Module: /app/apphls/forte/userapp/sr2_barb/cl0/sr2_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.IDENTIFIANT_METIER, t1.E
TAT_COURANT_PAIEMENT_PIC, t1.TYPE_PIECE_EN_PAIEMENT, t1.LIGNE_MA
NDAT_OID, t1.ORDRE_PAIEMENT_OID, t1.PRIORITE, t1.DATE_PRIORISATI
ON, t1.MONTANT_PAIEMENT, t1.LOT_PAIEMENT_OID, t1.NUMERO_CHEQUE,
t1.BUDGET_COLLECTIVITE_OID, t1.POSTE_COMPTABLE_OID, t1.MONTANT_R

      4,409,507       34,065          129.4    1.3   223.60   1608.27 4150585141
Module: RCE_RATTACHEMENT_ROLETITRE
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.BUDGET_COLLECTIVITE_OID,
 t1.EXERCICE_OID, t1.POSTE_COMPTABLE_OID, t1.JOURNEE_TRESORERIE_
OID, t1.DATE_JOURNEE_COMPTABLE, t1.ETAT_JOURNEE_COMPTABLE_PIC, t
1.EST_ARCHIVE, t1.EST_DERNIERE_JOURNEECOMPT_UTIL, t1.EST_JOURNEE
_COMPLEMENTAIRE  FROM GCPT_JOURNEE_COMPTABLE t1   WHERE (  ( t1.

      3,317,934      151,413           21.9    1.0   262.65   5129.99 3980367183
Module: Rapprocher_Tiers
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.BUDGET_COLLECTIVITE_OID,
 t1.NUMERO_COMPTE, t1.NATURE_COMPTA_AUXILIAIRE_PIC, t1.REFERENCE
_COMPTA_AUXILIAIRE, t1.DEBIT_COMPTE_AUXILIAIRE, t1.CREDIT_COMPTE
_AUXILIAIRE, t1.SENS_SOLDE_BALANCE_ENTREE_PIC, t1.SOLDE_BALANCE_
ENTREE, t1.COMPTE_COMPTABLE_JOURNEE_OID, t1.EST_MAJ_CE_JOUR, t1.

      2,601,965       10,669          243.9    0.8   368.01   1668.80 2735370824
Module: /app/apphls/forte/userapp/sr2_tech/cl0/sr2_te5@v
SELECT COUNT ( t1.OID )  FROM EXTR_TRAITEMENT t1, EXTR_TYPE_TRAI
TEMENT t2   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1
SQL ordered by Reads for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Disk Reads Threshold:      1000

                                                     CPU      Elapsd
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
.EXERCICE_OID = :var2 ) AND ( t1.TYPE_TRAITEMENT_OID = t2.OID )
AND (  ( t2.CODE_SOUS_TYPE_TRAIT_PIC = :var3 ) ) AND ( t1.TRAITE
MENT_CHAINE_OID IS NULL )  AND ( t1.DATE_CONSERVATION_DEMANDE >

      2,569,457      105,772           24.3    0.8   843.92   2912.83 3315890492
Module: /app/apphls/forte/userapp/sr1_tech/cl0/sr1_te5@v
SELECT t1.CODE_ETAT_TRAIT_PIC , COUNT ( t1.OID )  FROM EXTR_TRAI
TEMENT t1   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1
.EXERCICE_OID = :var2 ) AND ( t1.TRAITEMENT_CHAINE_OID IS NULL )
  AND ( t1.DATE_CONSERVATION_DEMANDE > :var3 ) AND ( t1.CODE_ETA
T_TRAIT_PIC IN ( :var4, :var5, :var6, :var7 ) ) AND (  ( t1.UTIL

      2,508,754          638        3,932.2    0.7   279.68   8190.26 3313330211
Module: sqr@vhpue12 (TNS V1-V3)
SELECT C.TIERS_OID, P.montant_paiement, OP.Objet_Depense, rpad(O
P.identifiant_metier,8,' '), rpad(C.nom,38,' '), rpad(C.prenom,3
8,' '), rpad(A.ligne1,32,' '), rpad(A.ligne2,32,' '), rpad(a.cod
e_postal,5,' '), rpad(a.ville,38,' '), OP.NATURE_OPC_PIC, OP.OID
, P.OID, C.rib_OID, TO_CHAR(p.DATE_JOURNEE_COMPTABLE, 'DD/MM/YYY

      2,418,692        4,605          525.2    0.7   853.54   2208.45 3376279263
Module: /app/apphls/forte/userapp/sr2_reco/cl0/sr2_re5@v
SELECT COUNT ( t1.OID )  FROM RCOO_PIECE_RECOUVREMENT t1   WHERE
 (  (  ( t1.BUDGET_COLLECTIVITE_OID = :var1 ) AND ( t1.BUDGET_CO
LLECTIVITE_OID = :var2 ) AND ( t1.BUDGET_PRINCIPAL_OID = :var3 )
 AND ( t1.EXERCICE_OID = :var4 ) AND ( t1.EXERCICE_OID = :var5 )
 AND ( t1.TYPE_PIECE_PIC = :var6 ) AND (  (  ( t1.ID_RECETTE >=

      1,831,478        2,843          644.2    0.5   158.97    965.22 3212333272
Module: Rapprocher_Tiers
SELECT COUNT ( DISTINCT t1.OID )  FROM DEPO_ORDREPAIEMENT_COMPTA
BLE t1, DEPO_PAIEMENT t3   WHERE (  (  ( t1.BUDGET_COLLECTIVITE_
OID = :var1 ) AND ( t1.EXERCICE_OID = :var2 ) AND ( t1.NATURE_OP
C_PIC IN ( :var3, :var4, :var5, :var6, :var7, :var8, :var9, :var
10, :var11, :var12, :var13, :var14, :var15, :var16, :var17, :var

      1,477,041          662        2,231.2    0.4   390.32    428.46 2200531970
Module: RCE.convertir_rcei_bordereau
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.POSTE_COMPTABLE_OID, t1.
BUDGET_COLLECTIVITE_OID, t1.EXERCICE_OID, t1.TITRE_OID, t1.NUM_L
IGNE, t1.CODE_PRODUIT_NATIONAL_PIC, t1.ETAT_LIGNE_PIC, t1.OBSERV
ATION_ETAT, t1.CODE_PRODUIT_LOC, t1.LIBELLE_PRODUIT_LOCAL, t1.DA
TE_ASP, t1.COMPTE_NATURE, t1.FONCTION, t1.OPERATION, t1.COMPTE_A

      1,431,875       54,574           26.2    0.4   335.75   1103.38  875621729
Module: /app/apphls/forte/userapp/sr1_tier/cl0/sr1_ti5@v
SELECT COUNT ( DISTINCT t1.OID )  FROM TIEO_TIERS t1, TIEO_ADRES
SE t3   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1.NOM
_RAISON_SOCIALE LIKE :var2 ) AND (  ( t1.EST_TIERS_REFERENCE = :
var3 ) OR ( t1.TIERS_REFERENCE_OID IS NULL )  ) AND ( t1.OID = t
3.TIERS_OID ) )

          -------------------------------------------------------------
SQL ordered by Executions for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Executions Threshold:       100

                                                CPU per    Elap per
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
   3,886,393       3,886,393              1.0       0.00        0.00  945954842
DECLARE  p1 NUMBER := :1;  p2 NUMBER := :2;  p3 NUMBER := :3;  p
4 NUMBER;  p5 NUMBER;  p6 NUMBER;  p7 NUMBER;  p8 NUMBER;  p9 NU
MBER;  p10 NUMBER;  p11 NUMBER;  p12 VARCHAR2(31);  p13 VARCHAR2
(31);  p14 VARCHAR2(31);  p15 VARCHAR2(31);  p16 NUMBER;  p17 NU
MBER;  p18 VARCHAR2(31);  p19 NUMBER;  BEGIN       SYS.LOGMNR_GT

   3,886,393       3,886,393              1.0       0.00        0.00 2156661458
SELECT O.SPARE2,O.TYPE#,O.OWNER#,U.NAME,O.NAME,O.SUBNAME   FROM
SYS.OBJ$ O,SYS.USER$ U  WHERE O.OBJ# = :b1  AND U.USER# = O.OWNE
R#

   1,422,592       1,414,275              1.0       0.00        0.00 2783936580
Module: sqr@vhpue12 (TNS V1-V3)
SELECT V1.DEFAULT_LABEL  FROM VCFG_PROPERTY V1, VCFG_PROPERTY V2
 WHERE V2.INTERNAL_NAME      = :1 and   V1.PARENT_SECTION_OID =
V2.oid and   V1.VALUE_INTEGER      = :2

   1,277,049       1,277,049              1.0       0.00        0.00  902311972
SELECT IO.SPARE2,IND.BO#,IND.TYPE#,IO.NAME,T.INTCOLS,T.TS#,TS.NA
ME,T.PROPERTY   FROM SYS.IND$ IND,SYS.OBJ$ IO,SYS.TAB$ T,SYS.TS$
 TS  WHERE IND.OBJ# = :b1  AND IO.OBJ# = IND.BO#  AND IO.TYPE# =
 2  AND T.OBJ# = IO.OBJ#  AND TS.TS# = T.TS#

     844,581         135,043              0.2       0.00        0.00 2135332492
Module: HISTO
SELECT OID FROM HISO_HISTORIQUE_ATTRIBUT_SAS WHERE XID || '' = :
B5 AND NOM_TABLE || '' = :B4 AND TYPE_ATTRIBUT_PIC + 0 = :B3 AND
 OBJET_METIER_OID = :B2 AND ETAT_OBJET + 0 = :B1

     765,730         765,730              1.0       0.00        0.00 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1

     709,538         153,074              0.2       0.00        0.00 3787147352
Module: HISTO
SELECT DISTINCT(HISTORIQUE_OBJET_OID) FROM HISO_HISTORIQUE_ATTRI
BUT_SAS WHERE XID || '' = :B4 AND NOM_TABLE || '' = :B3 AND OBJE
T_METIER_OID = :B2 AND ETAT_OBJET + 0 = :B1

     696,415         177,858              0.3       0.00        0.00  985279460
Module: HISTO
UPDATE HISO_TEMP_LOG L SET L.COMMITED_TRANS_OID = :B4 WHERE L.OB
JET_METIER_OID = :B3 AND L.TABLE_NAME = :B2 AND L.XID = :B1 AND
L.COMMITED_TRANS_OID = -1

     617,473         617,473              1.0       0.00        0.00 2356993604
Module: HISTO
INSERT INTO HISO_HISTORIQUE_ATTRIBUT_SAS ( OID ,VERSION ,TYPE_AT
TRIBUT_PIC ,SOUS_TYPE_OBJET_PIC ,POSTE_COMPTABLE_OID ,BUDGET_COL
LECTIVITE_OID ,HISTORIQUE_OBJET_OID ,NOUVELLE_VALEUR ,ANCIENNE_V
ALEUR ,OBJET_METIER_OID ,VERSION_HIS ,XID ,ROW_ID ,NOM_TABLE ,ET
AT_OBJET ,DATE_MODIFICATION ) VALUES ( PSO_SEQUENCE.NEXTVAL ,0 ,
SQL ordered by Executions for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Executions Threshold:       100

                                                CPU per    Elap per
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------

     556,464         556,464              1.0       0.00        0.00 1283203808
Module: HISTO
SELECT NVL(:B1 ,PSO_SEQUENCE.NEXTVAL) FROM DUAL

     527,353         527,353              1.0       0.00        0.00 1486648440
Module: HISTO
INSERT INTO HISO_HISTORIQUE_OBJET_SAS ( OID ,VERSION ,TYPE_OBJET
_PIC ,SOUS_TYPE_OBJET_PIC ,OBJET_METIER_OID ,ETAT_PIC ,VERSION_H
IS ,HISTORIQUE_OID ,IDENTIFIANT_METIER_OBJET ,IDENTIFIANT_METIER
_OBJET_PERE ,POSTE_COMPTABLE_OID ,BUDGET_COLLECTIVITE_OID ,XID ,
ROW_ID ,DATE_MODIFICATION ) VALUES ( :B11 ,0 ,:B10 ,NULL ,:B9 ,:

     521,269         521,265              1.0       0.00        0.00 2722983792
Module: PES_DepenseAller@vhpue11 (TNS V1-V3)
DECLARE p_Domaine VARCHAR2(15); p_Code VARCHAR2(20);p_ValeurPES
VARCHAR2(20);p_ValeurHelios NUMBER;BEGIN p_Domaine := :tArg1; p_
Code := :tArg2; p_ValeurPES := :tArg3; pk_tradexpress.pr_pesheli
os(p_Domaine,p_Code,p_ValeurPES,p_ValeurHelios);:nValeurHelios :
= p_ValeurHelios;END;

     521,231         297,225              0.6       0.00        0.00 2794156590
Module: PES_DepenseAller@vhpue11 (TNS V1-V3)
SELECT VALEUR_HELIOS FROM TYCO_PES_HELIOS WHERE UPPER(NOM_DOMAIN
E) = UPPER(:B3 ) AND UPPER(BALISE_XML) = UPPER(:B2 ) AND UPPER(V
ALEUR_PES) = UPPER(:B1 ) AND ROWNUM<2

     401,851         401,851              1.0       0.00        0.00 1250314626
SELECT T.INTCOLS,T.TS#,TS.NAME,T.PROPERTY   FROM SYS.TAB$ T,TS$
TS  WHERE T.OBJ# = :b1  AND TS.TS# = T.TS#

     390,293         390,275              1.0       0.00        0.00 3613996302
Module: Rapprocher_Tiers
INSERT INTO TIEO_TEMP_LISTE_PARAM ( OID, PARAMETRAGE_OID, POSTE_
COMPTABLE, B_COL_OID, NIVEAU_SERVICE, PC_DEFAUT, MODELE, COMBI_P
ARAM_OID, IDENTIFIE_TIERS, CERTAIN_POSSIBLE, DOMAINE_METIER, CRI
TERE_OID, CRITERE, NB_CARACT) VALUES ( PSO_SEQUENCE.NEXTVAL, :B1
3 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3

     383,858         383,859              1.0       0.00        0.00 2580294355
Module: /app/apphls/forte/userapp/sr2_refe/cl0/sr2_re5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.POSTE_COMPTA
BLE_OID, t1.TIERS_COLLECTIVITE_OID, t1.BLOC_NOTES_OID, t1.ADRESS
E_TIERS_COLLECTIVITE_OID, t1.BUDGET_COLL_FUSION_OID, t1.CODE_BUD
GET_COLLECTIVITE, t1.CODE_INSEE, t1.CODE_STATISTIQUE, t1.DATE_IN
ACTIVATION, t1.EST_CFU, t1.ETAT_PIC, t1.LIBELLE_BUDGET_COLLECTIV

     360,480         349,742              1.0       0.00        0.00 1754594796
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.POSTE_COMPTA
BLE_OID, t1.TIERS_REFERENCE_OID, t1.IDENTIFIANT_METIER, t1.NOM_R
AISON_SOCIALE, t1.COMPLEMENT_NOM, t1.NOM_PHONETIQUE, t1.CATEGORI
E_TIERS_PIC, t1.NATURE_JURIDIQUE_PIC, t1.EST_RESIDENT, t1.TELEPH
ONE_PRINCIPAL, t1.TELEPHONE_PORTABLE, t1.ADRESSE_ELECTRONIQUE, t
SQL ordered by Executions for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Executions Threshold:       100

                                                CPU per    Elap per
 Executions   Rows Processed   Rows per Exec    Exec (s)   Exec (s)  Hash Value
------------ --------------- ---------------- ----------- ---------- ----------

     337,386          11,017              0.0       0.00        0.00 3947170789
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.NUMERO_COMPT

          -------------------------------------------------------------
SQL ordered by Parse Calls for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Parse Calls Threshold:      1000

                           % Total
 Parse Calls  Executions   Parses  Hash Value
------------ ------------ -------- ----------
   3,886,393    3,886,393    11.33  945954842
DECLARE  p1 NUMBER := :1;  p2 NUMBER := :2;  p3 NUMBER := :3;  p
4 NUMBER;  p5 NUMBER;  p6 NUMBER;  p7 NUMBER;  p8 NUMBER;  p9 NU
MBER;  p10 NUMBER;  p11 NUMBER;  p12 VARCHAR2(31);  p13 VARCHAR2
(31);  p14 VARCHAR2(31);  p15 VARCHAR2(31);  p16 NUMBER;  p17 NU
MBER;  p18 VARCHAR2(31);  p19 NUMBER;  BEGIN       SYS.LOGMNR_GT

     765,729      765,730     2.23 3716207873
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,
order$=:6,cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:
1

     521,252      521,269     1.52 2722983792
Module: PES_DepenseAller@vhpue11 (TNS V1-V3)
DECLARE p_Domaine VARCHAR2(15); p_Code VARCHAR2(20);p_ValeurPES
VARCHAR2(20);p_ValeurHelios NUMBER;BEGIN p_Domaine := :tArg1; p_
Code := :tArg2; p_ValeurPES := :tArg3; pk_tradexpress.pr_pesheli
os(p_Domaine,p_Code,p_ValeurPES,p_ValeurHelios);:nValeurHelios :
= p_ValeurHelios;END;

     346,560      360,480     1.01 1754594796
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.POSTE_COMPTA
BLE_OID, t1.TIERS_REFERENCE_OID, t1.IDENTIFIANT_METIER, t1.NOM_R
AISON_SOCIALE, t1.COMPLEMENT_NOM, t1.NOM_PHONETIQUE, t1.CATEGORI
E_TIERS_PIC, t1.NATURE_JURIDIQUE_PIC, t1.EST_RESIDENT, t1.TELEPH
ONE_PRINCIPAL, t1.TELEPHONE_PORTABLE, t1.ADRESSE_ELECTRONIQUE, t

     202,558      203,337     0.59 3360605293
Module: RCE_RATTACHEMENT_ROLETITRE
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.NUMERO_COMPT
E, t1.NATURE_COMPTE_PIC, t1.COMPTE_SUBDIVISE, t1.DATE_CREATION,
t1.NUMERO_COMPTE_REFERENCE, t1.BUDGET_COLLECTIVITE_OID, t1.EXERC
ICE_OID, t1.LIBELLE_INITIAL, t1.LIBELLE_COMPLEMENTAIRE, t1.DATE_
SUPPRESSION, t1.EST_UN_COMPTE_D_EXECUTION, t1.NOMENCLATURE_REFER

     197,671      197,667     0.58 3360804353
select default$ from col$ where rowid=:1

     192,063      298,272     0.56 3606092998
Module: /app/appbat/forte/userapp/srv_dbtn/cl0/srv_db4@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.DATE_EXECUTION_CONTROLE,
 t1.CODE_ACTIVATION_PIC, t1.DOMAINE_METIER_PIC, t1.BUDGET_COLLEC
TIVITE_OID, t1.ELEMENT_OID, t1.EXERCICE_OID  FROM CTRO_RESULTAT_
ACTIVATION t1   WHERE (  ( t1.CODE_ACTIVATION_PIC = :var1 ) AND
( t1.ELEMENT_OID = :var2 ) )

     167,168      167,620     0.49 3626765431
Module: PLS.commit_avec_histo
SELECT DBMS_TRANSACTION.LOCAL_TRANSACTION_ID FROM DUAL

     164,217      164,636     0.48 2651614150
Module: RCE_RATTACHEMENT_ROLETITRE
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID  FROM NMCO_COMPT
SQL ordered by Parse Calls for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Parse Calls Threshold:      1000

                           % Total
 Parse Calls  Executions   Parses  Hash Value
------------ ------------ -------- ----------
E t1   WHERE (  ( t1.NUMERO_COMPTE = :var1 ) AND ( t1.EXERCICE_O
ID = :var2 ) AND ( t1.BUDGET_COLLECTIVITE_OID = :var3 ) AND ( t1
.DATE_SUPPRESSION IS NULL )  AND ( t1.NUMERO_COMPTE_REFERENCE =
:var4 ) AND ( t1.CLASSID >= :var5 ) AND ( t1.CLASSID < :var6 ) )

     162,372      162,374     0.47 3887251491
Module: Rapprocher_Tiers
INSERT INTO HISO_HISTORIQUE_SAS ( OID, VERSION, UTILISATEUR_OID,
 DATE_MODIFICATION, DOMAINE_METIER_PIC, DOMAINE_METIER_TRG, POST
E_COMPTABLE_OID, BUDGET_COLLECTIVITE_OID, XID, ETAT_PIC ) VALUES
 ( :var1, :var2, :var3, :var4, :var5, :var6, :var7, :var8, :var9
, :var10 )

     138,356      139,154     0.40 2597516481
Module: /app/apphls/forte/userapp/sr1_refe/cl0/sr1_re5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.TYPE_CLASSE_PIC, t1.DOMA
INE_METIER_PIC, t1.URL_CONSULTATION, t1.CODE_FONCTION_CONSULT_PI
C, t1.URL_RECTIFICATION, t1.CODE_FONCTION_RECTIF_PIC, t1.DETAIL_
PIECE_OID_EN_CONSULT, t1.URL_ECRAN_RECHERCHE, t1.CODE_FONCT_CONS
ULT_LISTE_PIC, t1.TYPE_CLASSE_FILS_PIC  FROM TYCO_TYPE_CLASSE t1

     137,908      139,113     0.40 1318905516
Module: /app/apphls/forte/userapp/sr1_comp/cl0/sr1_co5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.TYPE_PIECE_PIC, t1.DOMAI
NE_METIER_PIC, t1.TYPE_CLASSE_PIC, t1.EST_AUTORISE_FAC_SIMILE, t
1.EST_AUTORISE_RECTIFICATION, t1.EST_AUTORISE_EMARGEMENT, t1.EST
_AUTORISE_RECOUVREMENT, t1.EST_AUTORISE_PAIEMENT  FROM TYCO_TYPE
_PIECE t1   WHERE (  ( t1.TYPE_PIECE_PIC = :var1 ) )

     135,651      337,386     0.40 3947170789
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CLASSID, t1.NUMERO_COMPT
E, t1.NATURE_COMPTE_PIC, t1.COMPTE_SUBDIVISE, t1.DATE_CREATION,
t1.NUMERO_COMPTE_REFERENCE, t1.BUDGET_COLLECTIVITE_OID, t1.EXERC
ICE_OID, t1.EST_VALIDE, t1.EST_UN_COMPTE_D_EXECUTION, t1.NOMENCL
ATURE_REFERENCE_OID, t1.GROUPE_FONCTIONNEL_DEPENSE_OID, t1.GROUP

     132,423      132,425     0.39  412058021
Module: Rapprocher_Tiers
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.TIERS_OID, t1.EST_PRINCI
PALE, t1.EST_NPAI, t1.ADRESSE, t1.COMPLEMENT_ADRESSE, t1.CODE_PO
STAL, t1.LOCALITE, t1.PAYS, t1.POSTE_COMPTABLE_OID  FROM TIEO_AD
RESSE t1, TIEO_TIERS t2   WHERE (  ( t1.TIERS_OID = t2.OID ) AND
 (  ( t2.OID IN ( :var1 ) ) ) )

     131,130      131,128     0.38  444348142
Module: /app/apphls/forte/userapp/sr1_tier/cl0/sr1_ti5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.TIERS_OID, t1.EST_DEFAUT
, t1.EST_ACTIF, t1.DATE_FIN_VALIDITE, t1.TITULAIRE_COMPTE, t1.CO
DE_ETABLISSEMENT, t1.CODE_GUICHET, t1.NUMERO_COMPTE, t1.CLE_RIB,
 t1.CIP, t1.BIC, t1.TELEPHONE, t1.DATE_OUVERTURE, t1.POSTE_COMPT

          -------------------------------------------------------------
SQL ordered by Sharable Memory for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -469
-> End Sharable Memory Threshold:   1048576

Sharable Mem (b)  Executions  % Total  Hash Value
---------------- ------------ ------- ------------
       3,267,384            3     0.1    334398005
Module: sqr@vhpue12 (TNS V1-V3)
SELECT DECODE(:1,'', '',DECODE(U.SERVICE_ORDON, '0000000000', ''
,U.SERVICE_ORDON)), U.COMPTE, U.EXO, U.PIECE_OID, U.COMPTE_PIECE
_OID, U.NUM_BORD, U.NUM_PIECE, U.DATE_EXERCICE_PEC, U.DATE_PEC,
U.OBJ_PIECE, SUM(U.RESTE_A_PAYER1), SUM(U.RESTE_A_PAYER2)  from
(select /*+ ORDERED */ DM.SERVICE_ORDONNATEUR

       3,214,773            1     0.1    323759018
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.CODE_CATEGORIE, t1.CODE_
INSTRUCTION_PIC, t1.LIBELLE_CATEGORIE, t1.EST_AMORTISSABLE, t1.D
UREE_AMORTISSEMENT, t1.EST_SOUMIS_PRORATA, t1.BUDGET_COLLECTIVIT
E_OID, t1.DATE_DEBUT, t1.DATE_FIN, t1.POSTE_COMPTABLE_OID, t1.ES
T_NATIONALE, t1.MODE_AMORTISSEMENT_PIC, t1.EST_DIFFUSE  FROM INV

       3,149,264            1     0.1    646218342
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.FLUX_AMORTISSEMENT_OID,
t1.EXERCICE_PIECE, t1.TYPE_PIECE_ORIGINE_PIC, t1.NUMERO_PIECE, t
1.NUMERO_LIGNE, t1.DETAIL_PIECE_OID, t1.IMPUTATION_NATURE, t1.MO
NTANT_GLOBAL, t1.DATE_PRE_VISA, t1.ETAT_LOT_PIC, t1.EST_EN_INSTA
NCE, t1.BLOC_NOTES_OID, t1.EXERCICE_OID, t1.BUDGET_COLLECTIVITE_

       3,103,336            1     0.1   2936883902
Module: sqr@vhpue12 (TNS V1-V3)
SELECT U3.OrdreAffichage, U3.OrdreD, U3.SectionD, ltrim(rtrim(U3
.ChapArtD)), ltrim(rtrim(U3.CompteNatureD)), NVL(U3.numero_Piece
D, '0'), U3.typeOperationD, SUM(NVL(U3.Montant_EmissionD,0)), SU
M(NVL(U3.Montant_AnnulationD,0)), U3.datePECD, U3.NumePieceRefer
enceD, U3.PieceOidD  FROM (SELECT /*+ ORDERED */ '1'           O

       3,093,879            1     0.1   3603342067
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.FICHE_INVENTAIRE_OID, t1
.EXERCICE, t1.MONTANT_COMPTABILISE, t1.MONTANT_THEORIQUE  FROM I
NVO_AMORTISSEMENT t1, INVO_FICHE_INVENTAIRE t2   WHERE (  ( t1.F
ICHE_INVENTAIRE_OID = t2.OID ) AND (  ( t2.BUDGET_COLLECTIVITE_O
ID = :var1 ) AND (  (  ( t2.IDENTIFIANT_METIER IN ( :var2, :var3

       3,088,578            1     0.1   3257345967
Module: sqr@vhpue12 (TNS V1-V3)
SELECT U1.OrdreAffichage, U1.OrdreR, U1.SectionR, ltrim(rtrim(U1
.ChapArtR)), ltrim(rtrim(U1.CompteNatureIR)), U1.datePECR, NVL(T
O_CHAR(U1.numero_PieceR),'0'), SUM(U1.Montant_EmissionR), SUM(U1
.Montant_AnnulationR), U1.typeOperationR, TO_CHAR(U1.numePieceRe
ferenceR), U1.PieceOidR  FROM (SELECT /*+ ORDERED */ '1'

       3,015,098            1     0.1   1665484121
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.LOT_AMORTISSEMENT_OID, t
1.NUMERO_INVENTAIRE, t1.MONTANT_VENTILE_LIGNE, t1.FICHE_INVENTAI
RE_OID, t1.ETAT_ELEMENT_PIC, t1.BLOC_NOTES_OID, t1.EXERCICE_OID,
 t1.BUDGET_COLLECTIVITE_OID  FROM INVO_ELEMENT_AMORTISSEMENT t1,
 INVO_FICHE_INVENTAIRE t2   WHERE (  ( t1.FICHE_INVENTAIRE_OID =
SQL ordered by Sharable Memory for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -469
-> End Sharable Memory Threshold:   1048576

Sharable Mem (b)  Executions  % Total  Hash Value
---------------- ------------ ------- ------------

       2,933,269            1     0.1    366198286
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.BUDGET_COLLECTIVITE_OID,
 t1.IDENTIFIANT_METIER, t1.DESIGNATION, t1.DESIGNATION_COMPLEMEN
TAIRE, t1.CATEGORIE_OID, t1.DATE_ACQUISITION, t1.DATE_MISE_EN_SE
RVICE, t1.DATE_INTEGRATION, t1.IMPUTATION_INITIALE, t1.IMPUTATIO
N_DEFINITIVE, t1.DATE_SORTIE, t1.MODALITE_SORTIE_PIC, t1.PLUS_MO

       2,916,899            1     0.1   3791799407
Module: /app/appbat/forte/userapp/srv_batc/cl0/srv_ba5@v
SELECT t1.ROWID, t1.OID, t1.VERSION, t1.POSTE_COMPTABLE_OID, t1.
BUDGET_COLLECTIVITE_OID, t1.EST_TRAITE  FROM INVO_FLUX_AMORTISSE
MENT t1, INVO_LOT_AMORTISSEMENT t2, INVO_ELEMENT_AMORTISSEMENT t
3, INVO_FICHE_INVENTAIRE t4   WHERE (  ( t1.OID = t2.FLUX_AMORTI
SSEMENT_OID ) AND (  ( t2.OID = t3.LOT_AMORTISSEMENT_OID ) AND (

       2,424,576            1     0.1   2795399115
Module: /app/apphls/forte/userapp/sr1_tier/cl0/sr1_ti5@v
SELECT COUNT ( t1.OID )  FROM TYPO_PIECES_TIERS_NS t1   WHERE (
 ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1.BUDGET_COLLECTIVITE
_OID IN ( :var2, :var3, :var4, :var5, :var6, :var7, :var8, :var9
, :var10, :var11, :var12, :var13, :var14, :var15, :var16, :var17
, :var18, :var19, :var20, :var21, :var22, :var23, :var24, :var25

       2,419,440            1     0.1   3092887293
Module: /app/apphls/forte/userapp/sr1_tier/cl0/sr1_ti5@v
SELECT t1.OID, t1.TIERS_OID, t1.BUDGET_COLLECTIVITE_OID, t1.CODE
_TYPE_PIECE, t1.IDENTIFIANT_TIERS, t1.CODE_BUDGET_COLLECTIVITE,
t1.CODE_ETAT_PIECE, t1.NUMERO_PIECE, t1.DATE_EMISSION, t1.MONTAN
T_SOLDE, t1.POSTE_COMPTABLE_OID, t1.EXISTE_COMPTE_PIECE  FROM TY
PO_PIECES_TIERS_NS t1   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var

       2,102,421            2     0.1   4090003810
Module: /app/apphls/forte/userapp/sr2_tier/cl0/sr2_ti5@v
SELECT t1.OID, t1.TIERS_OID, t1.BUDGET_COLLECTIVITE_OID, t1.CODE
_TYPE_PIECE, t1.IDENTIFIANT_TIERS, t1.CODE_BUDGET_COLLECTIVITE,
t1.CODE_ETAT_PIECE, t1.NUMERO_PIECE, t1.DATE_EMISSION, t1.MONTAN
T_SOLDE, t1.POSTE_COMPTABLE_OID, t1.EXISTE_COMPTE_PIECE  FROM TY
PO_PIECES_TIERS_NS t1   WHERE (  ( t1.POSTE_COMPTABLE_OID = :var

       2,096,197            2     0.1   3158730200
Module: /app/apphls/forte/userapp/sr2_tier/cl0/sr2_ti5@v
SELECT COUNT ( t1.OID )  FROM TYPO_PIECES_TIERS_NS t1   WHERE (
 ( t1.POSTE_COMPTABLE_OID = :var1 ) AND ( t1.BUDGET_COLLECTIVITE
_OID IN ( :var2, :var3, :var4, :var5, :var6, :var7, :var8, :var9
, :var10, :var11, :var12, :var13, :var14, :var15, :var16, :var17

          -------------------------------------------------------------
SQL ordered by Version Count for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> End Version Count Threshold:        20

 Version
   Count  Executions   Hash Value
-------- ------------ ------------
      24        1,184    213331497
Module: MARQUAGE_A_PRIORI
INSERT INTO DEPO_VENTILATION_MARCHE ( OID, VERSION, VENTILATION_
AVANCE_HT, VENTILATION_ACOMPTE_HT, VENTILATION_REVISION_HT, VENT
ILATION_TVA, VENTILATION_INT_MORATOIRES, VENTILATION_MONTANT_HT_
FACTURE, VENTILATION_RETENUE_GARANTIE, VENTILATION_RETENUES_ACOM
PTE, VENTILATION_RETENUES_AVANCES, VENTILATION_DIVERS, VENTILATI

          -------------------------------------------------------------
Instance Activity Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
active txn count during cleanout           2,487,905           58.4          6.6
background checkpoints completed                 128            0.0          0.0
background checkpoints started                   128            0.0          0.0
background timeouts                           51,753            1.2          0.1
branch node splits                             1,963            0.1          0.0
buffer is not pinned count             4,954,635,896      116,267.8     13,133.8
buffer is pinned count                36,353,258,001      853,082.5     96,365.4
bytes received via SQL*Net from c     35,674,525,739      837,155.1     94,566.2
bytes received via SQL*Net from d         10,380,695          243.6         27.5
bytes sent via SQL*Net to client      61,483,518,131    1,442,800.9    162,980.8
bytes sent via SQL*Net to dblink          11,609,014          272.4         30.8
Cached Commit SCN referenced               1,333,270           31.3          3.5
calls to get snapshot scn: kcmgss        138,883,663        3,259.1        368.2
calls to kcmgas                            4,493,349          105.4         11.9
calls to kcmgcs                              725,516           17.0          1.9
change write time                             74,926            1.8          0.2
cleanout - number of ktugct calls          3,125,010           73.3          8.3
cluster key scan block gets               36,388,769          853.9         96.5
cluster key scans                         23,360,821          548.2         61.9
commit cleanout failures: block l            685,559           16.1          1.8
commit cleanout failures: buffer               4,168            0.1          0.0
commit cleanout failures: callbac             40,134            0.9          0.1
commit cleanout failures: cannot               1,259            0.0          0.0
commit cleanouts                          12,897,796          302.7         34.2
commit cleanouts successfully com         12,166,676          285.5         32.3
Commit SCN cached                                121            0.0          0.0
commit txn count during cleanout           2,999,358           70.4          8.0
consistent changes                        79,054,426        1,855.1        209.6
consistent gets                        7,864,314,815      184,547.7     20,846.8
consistent gets - examination          1,751,812,433       41,108.9      4,643.7
CPU used by this session                  18,443,313          432.8         48.9
CPU used when call started                18,383,278          431.4         48.7
CR blocks created                            719,765           16.9          1.9
current blocks converted for CR                  497            0.0          0.0
cursor authentications                       326,523            7.7          0.9
data blocks consistent reads - un         17,110,539          401.5         45.4
db block changes                         199,130,500        4,672.9        527.9
db block gets                            248,696,195        5,836.0        659.2
DBWR buffers scanned                     149,981,589        3,519.5        397.6
DBWR checkpoint buffers written            2,501,977           58.7          6.6
DBWR checkpoints                                 133            0.0          0.0
DBWR free buffers found                  144,198,084        3,383.8        382.2
DBWR lru scans                               207,438            4.9          0.6
DBWR make free requests                    1,756,571           41.2          4.7
DBWR revisited being-written buff                  2            0.0          0.0
DBWR summed scan depth                   149,981,589        3,519.5        397.6
DBWR transaction table writes                  2,886            0.1          0.0
DBWR undo block writes                     3,013,342           70.7          8.0
deferred (CURRENT) block cleanout          4,445,451          104.3         11.8
DFO trees parallelized                           535            0.0          0.0
dirty buffers inspected                    1,784,851           41.9          4.7
enqueue conversions                          415,147            9.7          1.1
enqueue deadlocks                                  2            0.0          0.0
enqueue releases                          17,856,024          419.0         47.3
enqueue requests                          17,859,071          419.1         47.3
enqueue timeouts                               3,054            0.1          0.0
Instance Activity Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
enqueue waits                                  2,018            0.1          0.0
exchange deadlocks                                27            0.0          0.0
execute count                             72,110,211        1,692.2        191.2
failed probes on index block recl             73,702            1.7          0.2
free buffer inspected                      1,795,823           42.1          4.8
free buffer requested                    313,835,835        7,364.6        831.9
hot buffers moved to head of LRU         180,704,689        4,240.5        479.0
immediate (CR) block cleanout app          1,449,498           34.0          3.8
immediate (CURRENT) block cleanou          2,359,353           55.4          6.3
index crx upgrade (found)                        116            0.0          0.0
index crx upgrade (positioned)             1,326,386           31.1          3.5
index fast full scans (direct rea              3,018            0.1          0.0
index fast full scans (full)                 130,357            3.1          0.4
index fast full scans (rowid rang             60,124            1.4          0.2
index fetch by key                       432,478,142       10,148.7      1,146.4
index scans kdiixs1                    3,770,346,450       88,476.7      9,994.5
leaf node splits                             314,248            7.4          0.8
leaf node 90-10 splits                        33,638            0.8          0.1
logons cumulative                             55,541            1.3          0.2
messages received                          2,395,762           56.2          6.4
messages sent                              2,395,762           56.2          6.4
no buffer to keep pinned count                   727            0.0          0.0
no work - consistent read gets         6,034,665,862      141,612.3     15,996.7
opened cursors cumulative                 34,289,616          804.7         90.9
Parallel operations downgraded 75                535            0.0          0.0
parse count (failures)                            34            0.0          0.0
parse count (hard)                           781,849           18.4          2.1
parse count (total)                       34,298,459          804.9         90.9
parse time cpu                               267,957            6.3          0.7
parse time elapsed                           674,210           15.8          1.8
physical reads                           335,361,776        7,869.8        889.0
physical reads direct                     27,853,727          653.6         73.8
physical writes                           20,096,716          471.6         53.3
physical writes direct                    10,033,317          235.5         26.6
physical writes non checkpoint            19,595,874          459.9         51.9
pinned buffers inspected                       3,951            0.1          0.0
prefetch clients - default                    59,006            1.4          0.2
prefetched blocks                         99,603,496        2,337.3        264.0
prefetched blocks aged out before                 85            0.0          0.0
process last non-idle time                    42,612            1.0          0.1
PX local messages recv'd                     278,233            6.5          0.7
PX local messages sent                       278,233            6.5          0.7
queries parallelized                             535            0.0          0.0
recursive aborts on index block r                 58            0.0          0.0
recursive calls                           86,966,566        2,040.8        230.5
recursive cpu usage                        4,890,538          114.8         13.0
redo blocks written                       67,176,120        1,576.4        178.1
redo buffer allocation retries                 1,929            0.1          0.0
redo entries                              99,157,033        2,326.9        262.9
redo log space requests                          822            0.0          0.0
redo log space wait time                       1,276            0.0          0.0
redo ordering marks                               99            0.0          0.0
redo size                             20,297,204,836      476,303.7     53,803.9
redo synch time                              215,562            5.1          0.6
redo synch writes                            352,257            8.3          0.9
redo wastage                             129,635,268        3,042.1        343.6
Instance Activity Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

Statistic                                      Total     per Second    per Trans
--------------------------------- ------------------ -------------- ------------
redo write time                              265,238            6.2          0.7
redo writer latching time                        178            0.0          0.0
redo writes                                  527,901           12.4          1.4
rollback changes - undo records a            751,532           17.6          2.0
rows fetched via callback                324,879,095        7,623.8        861.2
session connect time                               0            0.0          0.0
session logical reads                  8,112,795,353      190,378.6     21,505.4
session pga memory                     1,193,972,256       28,018.3      3,165.0
session pga memory max                26,656,264,472      625,528.3     70,660.5
session uga memory                   408,740,388,016    9,591,692.6  1,083,490.8
session uga memory max                45,405,358,448    1,065,503.3    120,360.7
shared hash latch upgrades - no w         14,371,188          337.2         38.1
shared hash latch upgrades - wait              3,108            0.1          0.0
sorts (disk)                                     455            0.0          0.0
sorts (memory)                            17,205,281          403.8         45.6
sorts (rows)                           4,890,617,621      114,765.5     12,964.1
SQL*Net roundtrips to/from client        186,351,081        4,373.0        494.0
SQL*Net roundtrips to/from dblink              6,048            0.1          0.0
summed dirty queue length                  9,356,613          219.6         24.8
switch current to new buffer               2,108,890           49.5          5.6
table fetch by rowid                  19,047,185,380      446,970.1     50,490.4
table fetch continued row                  3,885,626           91.2         10.3
table scan blocks gotten               1,082,738,189       25,408.0      2,870.1
table scan rows gotten                37,768,642,996      886,296.6    100,117.3
table scans (cache partitions)                   527            0.0          0.0
table scans (direct read)                      2,175            0.1          0.0
table scans (long tables)                      7,124            0.2          0.0
table scans (rowid ranges)                     4,593            0.1          0.0
table scans (short tables)                 8,215,289          192.8         21.8
transaction rollbacks                            522            0.0          0.0
transaction tables consistent rea                400            0.0          0.0
transaction tables consistent rea             78,166            1.8          0.2
user calls                               186,123,390        4,367.7        493.4
user commits                                 377,013            8.9          1.0
user rollbacks                                   231            0.0          0.0
workarea executions - multipass                    2            0.0          0.0
workarea executions - onepass                     36            0.0          0.0
workarea executions - optimal             18,242,298          428.1         48.4
write clones created in backgroun                  3            0.0          0.0
write clones created in foregroun              3,950            0.1          0.0
          -------------------------------------------------------------
Tablespace IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
TBL_D_1
   112,857,254   2,648    0.8     1.8      633,253       15    485,534    1.4
TBL_I_1
    20,701,731     486    1.4     1.2    1,702,519       40     37,752    1.5
TBL_D_P19
    11,766,196     276    1.1     1.0       43,342        1    204,226    1.3
TBL_D_P14
     8,082,386     190    0.9     1.0       34,452        1    201,299    1.1
TBL_D_P10
     3,463,041      81    1.2     1.0       42,458        1      5,697    1.9
TBL_I_P19
     2,991,213      70    1.8     1.2      274,538        6     24,447    2.6
UNDOTBS1
        24,425       1    2.5     1.0    3,017,156       71      2,330    3.2
TEMP
     2,038,988      48    1.0    16.9      922,414       22          0    0.0
TBL_I_P14
     2,405,428      56    1.7     1.1      233,466        5     25,417    2.8
TBL_D_P09
     2,404,292      56    1.2     1.0       30,799        1     10,416    1.1
TBL_D_P18
     2,347,252      55    1.3     1.0       28,170        1      6,322    1.8
TBL_D_HISO
     2,309,092      54    1.0     1.1       55,778        1          4    0.0
TBL_D_P16
     2,191,639      51    1.2     1.0       24,571        1     10,145    3.3
TBL_D_P04
     2,083,383      49    1.1     1.0       25,977        1      2,846    3.1
TBL_D_P02
     1,997,980      47    1.2     1.1       31,338        1      1,433    2.1
TBL_I_P10
     1,710,076      40    2.1     1.0      255,164        6        236    3.7
TBL_D_P01
     1,898,803      45    1.1     1.2       24,427        1        939    3.6
TBL_D_P06
     1,686,448      40    1.3     1.0       26,418        1      1,857    1.1
TBL_D_P12
     1,688,129      40    1.0     1.0       10,866        0     21,363    0.8
TBL_D_P08
     1,589,515      37    1.1     1.0       27,247        1      2,580    0.7
TBL_D_P23
     1,578,056      37    1.3     1.0       27,654        1      2,241    2.4
TBL_D_P21
     1,383,085      32    1.1     1.0       11,160        0     16,635    2.6
TBL_D_P15
     1,375,787      32    1.0     1.0       15,661        0        391    1.7
TBL_I_P09
     1,188,550      28    2.0     1.1      181,098        4      7,260    3.8
TBL_I_HISO
       656,843      15    2.2     1.1      703,125       16         28   22.5
TBL_D_P17
     1,299,240      30    1.3     1.0       17,512        0        827    2.1
Tablespace IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
TBL_I_P16
     1,085,934      25    1.9     1.0      151,615        4      2,548    4.5
TBL_I_P18
     1,026,940      24    2.2     1.0      166,340        4      1,411    5.1
TBL_I_P02
       983,325      23    2.2     1.1      187,388        4      4,816    2.2
TBL_I_P06
       942,601      22    1.9     1.1      151,923        4         39   10.8
TBL_I_P04
       925,534      22    2.2     1.1      156,545        4      1,702    2.3
TBL_D_P03
     1,029,028      24    1.0     1.0       11,716        0      1,505    0.9
TBL_I_P23
       830,621      19    2.1     1.0      170,543        4      2,904    3.7
TBL_D_P11
       961,943      23    1.5     1.0       19,571        0      2,115    2.7
TBL_I_P08
       799,444      19    2.1     1.1      164,494        4        716    2.1
TBL_I_P01
       706,323      17    1.9     1.0      124,666        3      3,618    1.8
TBL_I_P17
       615,667      14    2.3     1.1      107,960        3         81    2.6
TBL_I_P11
       569,706      13    2.3     1.1      117,231        3      2,189    2.6
TBL_I_P15
       573,370      13    1.9     1.1       94,729        2         35    5.7
TBL_D_P07
       631,507      15    1.0     1.1       10,170        0        264    2.5
TBL_I_P12
       503,256      12    2.0     1.0       64,190        2      2,370    1.3
TBL_D_P22
       539,008      13    0.9     1.1        7,131        0      1,614    1.6
TBL_I_P21
       475,975      11    2.1     1.0       67,885        2      3,846    3.1
STATSPACK
       496,074      12    2.0     1.1       32,892        1          0    0.0
TBL_I_P03
       418,116      10    1.9     1.0       65,383        2         39    1.5
TBL_D_P05
       422,396      10    0.9     1.0        4,648        0      1,153    1.6
TBL_D_P13
       402,722       9    0.8     1.0        4,194        0          2    0.0
TBL_I_P07
       292,945       7    2.2     1.1       54,039        1        249    4.4
TBL_D_P24
       306,714       7    1.2     1.1        5,232        0          5    8.0
TBL_I_P22
       234,910       6    2.2     1.1       42,032        1         95    2.8
TBL_D_P20
       220,569       5    1.0     1.1        3,998        0          5   16.0
TBL_I_P24
       155,266       4    2.7     1.1       32,204        1         11    6.4
Tablespace IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSTEM
       170,570       4    0.9     1.3        8,431        0        931   24.4
TBL_I_P05
       148,313       3    2.4     1.1       26,489        1      1,045    2.0
TBL_I_P13
       129,550       3    2.5     1.1       22,474        1          6    5.0
TBL_I_P20
       106,896       3    2.6     1.1       22,226        1         19    6.8
TBL_D_FLUX_1
        12,516       0    1.4     6.8        2,473        0         34   14.4
STATSTEMP
         8,428       0    0.2    12.5        5,251        0          0    0.0
TOOLS
         3,158       0    1.6     2.5        1,811        0          0    0.0
TBL_I_FLUX_1
         2,725       0    5.6     1.0        2,122        0          0    0.0
TBL_D_5
         1,544       0    7.5     1.0          248        0          0    0.0
TBL_D_4
         1,542       0    7.5     1.0          248        0          0    0.0
TBL_D_2
           771       0    7.6     1.0          124        0          0    0.0
          -------------------------------------------------------------
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
STATSPACK                /prod01/u08/oradata/HPRD1/statspack_HPRD1_01.dbf
       496,074      12    2.0     1.1       32,892        1          0

STATSTEMP                /prod01/u09/oradata/HPRD1/statstemp_HPRD1_01.dbf
         8,428       0    0.2    12.5        5,251        0          0

SYSTEM                   /prod01/u01/oradata/HPRD1/system_HPRD1_01.dbf
       170,570       4    0.9     1.3        8,431        0        931   24.4

TBL_D_FLUX_1             /prod01/u03/oradata/HPRD1/tbl_d_flux_1_HPRD1_01.dbf
        12,516       0    1.4     6.8        2,473        0         34   14.4

TBL_D_HISO               /prod01/u01/oradata/HPRD1/tbl_d_hiso_HPRD1_01.dbf
       512,979      12    0.9     1.0        3,032        0          0
                         /prod01/u01/oradata/HPRD1/tbl_d_hiso_HPRD1_05.dbf
        82,362       2    1.3     1.5        4,653        0          1    0.0
                         /prod01/u02/oradata/HPRD1/tbl_d_hiso_HPRD1_02.dbf
       506,088      12    0.9     1.0        5,119        0          0
                         /prod01/u02/oradata/HPRD1/tbl_d_hiso_HPRD1_06.dbf
        86,111       2    1.3     1.5        4,049        0          0
                         /prod01/u03/oradata/HPRD1/tbl_d_hiso_HPRD1_03.dbf
       485,909      11    1.0     1.0       19,998        0          0
                         /prod01/u03/oradata/HPRD1/tbl_d_hiso_HPRD1_07.dbf
        82,834       2    1.5     1.4        4,856        0          1    0.0
                         /prod01/u04/oradata/HPRD1/tbl_d_hiso_HPRD1_04.dbf
       472,161      11    1.0     1.1        6,410        0          0
                         /prod01/u04/oradata/HPRD1/tbl_d_hiso_HPRD1_08.dbf
        80,648       2    1.4     1.3        7,661        0          2    0.0

TBL_D_P01                /prod01/u01/oradata/HPRD1/tbl_d_p01_HPRD1_01.dbf
       940,726      22    1.1     1.2       11,575        0        599    3.6
                         /prod01/u01/oradata/HPRD1/tbl_d_p01_HPRD1_02.dbf
       958,077      22    1.1     1.2       12,852        0        340    3.7

TBL_D_P02                /prod01/u02/oradata/HPRD1/tbl_d_p02_HPRD1_01.dbf
       997,780      23    1.2     1.1       14,118        0        332    2.6
                         /prod01/u02/oradata/HPRD1/tbl_d_p02_HPRD1_02.dbf
     1,000,200      23    1.1     1.1       17,220        0      1,101    2.0

TBL_D_P03                /prod01/u03/oradata/HPRD1/tbl_d_p03_HPRD1_01.dbf
       515,943      12    1.0     1.0        6,026        0          6    1.7
                         /prod01/u03/oradata/HPRD1/tbl_d_p03_HPRD1_02.dbf
       513,085      12    1.0     1.0        5,690        0      1,499    0.9

TBL_D_P04                /prod01/u04/oradata/HPRD1/tbl_d_p04_HPRD1_01.dbf
     1,036,236      24    1.1     1.0       11,644        0      1,546    2.8
                         /prod01/u04/oradata/HPRD1/tbl_d_p04_HPRD1_02.dbf
     1,047,147      25    1.1     1.0       14,333        0      1,300    3.5

TBL_D_P05                /prod01/u01/oradata/HPRD1/tbl_d_p05_HPRD1_01.dbf
       204,807       5    0.9     1.0        2,834        0        545    1.5
                         /prod01/u01/oradata/HPRD1/tbl_d_p05_HPRD1_02.dbf
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
       217,589       5    0.9     1.0        1,814        0        608    1.7

TBL_D_P06                /prod01/u02/oradata/HPRD1/tbl_d_p06_HPRD1_01.dbf
       837,371      20    1.3     1.0       11,657        0        583    0.4
                         /prod01/u02/oradata/HPRD1/tbl_d_p06_HPRD1_02.dbf
       849,077      20    1.3     1.0       14,761        0      1,274    1.4

TBL_D_P07                /prod01/u03/oradata/HPRD1/tbl_d_p07_HPRD1_01.dbf
       315,736       7    1.0     1.1        4,803        0         51    4.3
                         /prod01/u03/oradata/HPRD1/tbl_d_p07_HPRD1_02.dbf
       315,771       7    1.0     1.1        5,367        0        213    2.0

TBL_D_P08                /prod01/u04/oradata/HPRD1/tbl_d_p08_HPRD1_01.dbf
       762,054      18    1.2     1.0       15,954        0        112    0.9
                         /prod01/u04/oradata/HPRD1/tbl_d_p08_HPRD1_02.dbf
       827,461      19    1.1     1.0       11,293        0      2,468    0.6

TBL_D_P09                /prod01/u01/oradata/HPRD1/tbl_d_p09_HPRD1_01.dbf
     1,221,641      29    1.2     1.0       19,543        0      3,099    1.2
                         /prod01/u01/oradata/HPRD1/tbl_d_p09_HPRD1_02.dbf
     1,182,651      28    1.1     1.0       11,256        0      7,317    1.1

TBL_D_P10                /prod01/u02/oradata/HPRD1/tbl_d_p10_HPRD1_01.dbf
     1,714,514      40    1.2     1.0       19,332        0      2,457    1.2
                         /prod01/u02/oradata/HPRD1/tbl_d_p10_HPRD1_02.dbf
     1,748,527      41    1.2     1.0       23,126        1      3,240    2.4

TBL_D_P11                /prod01/u03/oradata/HPRD1/tbl_d_p11_HPRD1_01.dbf
       470,532      11    1.6     1.0       10,128        0        871    2.9
                         /prod01/u03/oradata/HPRD1/tbl_d_p11_HPRD1_02.dbf
       491,411      12    1.5     1.0        9,443        0      1,244    2.5

TBL_D_P12                /prod01/u04/oradata/HPRD1/tbl_d_p12_HPRD1_01.dbf
       871,781      20    0.9     1.0        5,681        0      7,917    0.8
                         /prod01/u04/oradata/HPRD1/tbl_d_p12_HPRD1_02.dbf
       816,348      19    1.0     1.0        5,185        0     13,446    0.8

TBL_D_P13                /prod01/u01/oradata/HPRD1/tbl_d_p13_HPRD1_01.dbf
       192,664       5    0.9     1.0        2,007        0          1    0.0
                         /prod01/u01/oradata/HPRD1/tbl_d_p13_HPRD1_02.dbf
       210,058       5    0.8     1.0        2,187        0          1    0.0

TBL_D_P14                /prod01/u02/oradata/HPRD1/tbl_d_p14_HPRD1_01.dbf
     4,068,572      95    0.9     1.0       17,669        0     63,286    1.2
                         /prod01/u02/oradata/HPRD1/tbl_d_p14_HPRD1_02.dbf
     4,013,814      94    0.9     1.0       16,783        0    138,013    1.0

TBL_D_P15                /prod01/u03/oradata/HPRD1/tbl_d_p15_HPRD1_01.dbf
       687,053      16    1.0     1.0        7,326        0          0
                         /prod01/u03/oradata/HPRD1/tbl_d_p15_HPRD1_02.dbf
       688,734      16    1.0     1.0        8,335        0        391    1.7

File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
TBL_D_P16                /prod01/u04/oradata/HPRD1/tbl_d_p16_HPRD1_01.dbf
     1,078,055      25    1.3     1.0        9,614        0      4,402    3.7
                         /prod01/u04/oradata/HPRD1/tbl_d_p16_HPRD1_02.dbf
     1,113,584      26    1.2     1.0       14,957        0      5,743    3.1

TBL_D_P17                /prod01/u01/oradata/HPRD1/tbl_d_p17_HPRD1_01.dbf
       625,439      15    1.4     1.0       10,453        0        469    2.8
                         /prod01/u01/oradata/HPRD1/tbl_d_p17_HPRD1_02.dbf
       673,801      16    1.3     1.0        7,059        0        358    1.2

TBL_D_P18                /prod01/u02/oradata/HPRD1/tbl_d_p18_HPRD1_01.dbf
     1,152,190      27    1.4     1.0       13,108        0      1,783    1.7
                         /prod01/u02/oradata/HPRD1/tbl_d_p18_HPRD1_02.dbf
     1,195,062      28    1.3     1.0       15,062        0      4,539    1.8

TBL_D_P19                /prod01/u03/oradata/HPRD1/tbl_d_p19_HPRD1_01.dbf
     6,180,358     145    1.0     1.0       22,832        1     38,871    1.3
                         /prod01/u03/oradata/HPRD1/tbl_d_p19_HPRD1_02.dbf
     5,585,838     131    1.1     1.0       20,510        0    165,355    1.3

TBL_D_P20                /prod01/u04/oradata/HPRD1/tbl_d_p20_HPRD1_01.dbf
       107,603       3    1.0     1.1        1,710        0          2   15.0
                         /prod01/u04/oradata/HPRD1/tbl_d_p20_HPRD1_02.dbf
       112,966       3    0.9     1.1        2,288        0          3   16.7

TBL_D_P21                /prod01/u01/oradata/HPRD1/tbl_d_p21_HPRD1_01.dbf
       690,423      16    1.1     1.0        5,155        0      5,187    3.0
                         /prod01/u01/oradata/HPRD1/tbl_d_p21_HPRD1_02.dbf
       692,662      16    1.1     1.0        6,005        0     11,448    2.4

TBL_D_P22                /prod01/u02/oradata/HPRD1/tbl_d_p22_HPRD1_01.dbf
       273,412       6    0.9     1.1        3,516        0        763    1.8
                         /prod01/u02/oradata/HPRD1/tbl_d_p22_HPRD1_02.dbf
       265,596       6    0.9     1.1        3,615        0        851    1.4

TBL_D_P23                /prod01/u03/oradata/HPRD1/tbl_d_p23_HPRD1_01.dbf
       783,055      18    1.3     1.0       13,052        0        768    2.4
                         /prod01/u03/oradata/HPRD1/tbl_d_p23_HPRD1_02.dbf
       795,001      19    1.3     1.0       14,602        0      1,473    2.4

TBL_D_P24                /prod01/u04/oradata/HPRD1/tbl_d_p24_HPRD1_01.dbf
       150,421       4    1.2     1.1        2,790        0          4    7.5
                         /prod01/u04/oradata/HPRD1/tbl_d_p24_HPRD1_02.dbf
       156,293       4    1.2     1.1        2,442        0          1   10.0

TBL_D_1                  /prod01/u01/oradata/HPRD1/tbl_d_1_HPRD1_01.dbf
    14,531,292     341    0.9     1.6       89,591        2     15,691    2.0
                         /prod01/u01/oradata/HPRD1/tbl_d_1_HPRD1_05.dbf
    14,141,181     332    0.9     1.8       78,691        2     66,618    1.4
                         /prod01/u02/oradata/HPRD1/tbl_d_1_HPRD1_02.dbf
    13,570,791     318    0.8     1.7       79,206        2     20,125    1.8
                         /prod01/u02/oradata/HPRD1/tbl_d_1_HPRD1_06.dbf
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
    14,534,099     341    0.9     1.8       78,380        2    104,147    1.4
TBL_D_1                  /prod01/u03/oradata/HPRD1/tbl_d_1_HPRD1_03.dbf
    13,556,081     318    0.8     1.7       78,499        2     34,229    1.8
                         /prod01/u03/oradata/HPRD1/tbl_d_1_HPRD1_07.dbf
    14,378,644     337    0.8     1.9       79,651        2    100,242    1.5
                         /prod01/u04/oradata/HPRD1/tbl_d_1_HPRD1_04.dbf
    13,743,471     323    0.8     1.7       68,452        2     45,673    1.3
                         /prod01/u04/oradata/HPRD1/tbl_d_1_HPRD1_08.dbf
    14,401,695     338    0.7     1.8       80,783        2     98,809    1.3

TBL_D_2                  /prod01/u01/oradata/HPRD1/tbl_d_2_HPRD1_01.dbf
           771       0    7.6     1.0          124        0          0

TBL_D_4                  /prod01/u03/oradata/HPRD1/tbl_d_4_HPRD1_01.dbf
           772       0    7.5     1.0          124        0          0
                         /prod01/u03/oradata/HPRD1/tbl_d_4_HPRD1_02.dbf
           770       0    7.5     1.0          124        0          0

TBL_D_5                  /prod01/u03/oradata/HPRD1/tbl_d_5_HPRD1_01.dbf
           772       0    7.4     1.0          124        0          0
                         /prod01/u03/oradata/HPRD1/tbl_d_5_HPRD1_02.dbf
           772       0    7.5     1.0          124        0          0

TBL_I_FLUX_1             /prod01/u01/oradata/HPRD1/tbl_i_flux_1_HPRD1_01.dbf
         2,725       0    5.6     1.0        2,122        0          0

TBL_I_HISO               /prod01/u01/oradata/HPRD1/tbl_i_hiso_HPRD1_01.dbf
        50,324       1    3.4     1.1       47,038        1          0
                         /prod01/u01/oradata/HPRD1/tbl_i_hiso_HPRD1_05.dbf
       125,832       3    2.0     1.0      132,154        3          7    0.0
                         /prod01/u02/oradata/HPRD1/tbl_i_hiso_HPRD1_02.dbf
        52,422       1    3.3     1.0       49,012        1          0
                         /prod01/u02/oradata/HPRD1/tbl_i_hiso_HPRD1_06.dbf
       101,466       2    2.0     1.1      100,165        2          2    0.0
                         /prod01/u03/oradata/HPRD1/tbl_i_hiso_HPRD1_03.dbf
        50,939       1    3.0     1.1       47,274        1          1    0.0
                         /prod01/u03/oradata/HPRD1/tbl_i_hiso_HPRD1_07.dbf
        96,865       2    1.6     1.0      116,606        3          1    0.0
                         /prod01/u04/oradata/HPRD1/tbl_i_hiso_HPRD1_04.dbf
        48,715       1    3.0     1.1       45,632        1          1    0.0
                         /prod01/u04/oradata/HPRD1/tbl_i_hiso_HPRD1_08.dbf
       130,280       3    1.5     1.0      165,244        4         16   39.4

TBL_I_P01                /prod01/u02/oradata/HPRD1/tbl_i_p01_HPRD1_01.dbf
       349,324       8    1.9     1.0       57,911        1      1,835    2.0
                         /prod01/u02/oradata/HPRD1/tbl_i_p01_HPRD1_02.dbf
       356,999       8    1.9     1.0       66,755        2      1,783    1.5

TBL_I_P02                /prod01/u03/oradata/HPRD1/tbl_i_p02_HPRD1_01.dbf
       499,546      12    2.2     1.1       94,296        2      2,228    2.6
                         /prod01/u03/oradata/HPRD1/tbl_i_p02_HPRD1_02.dbf
       483,779      11    2.2     1.1       93,092        2      2,588    2.0
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------

TBL_I_P03                /prod01/u04/oradata/HPRD1/tbl_i_p03_HPRD1_01.dbf
       207,819       5    1.9     1.0       33,478        1         26    1.9
                         /prod01/u04/oradata/HPRD1/tbl_i_p03_HPRD1_02.dbf
       210,297       5    1.9     1.0       31,905        1         13    0.8

TBL_I_P04                /prod01/u01/oradata/HPRD1/tbl_i_p04_HPRD1_01.dbf
       462,691      11    2.2     1.1       78,798        2        872    2.3
                         /prod01/u01/oradata/HPRD1/tbl_i_p04_HPRD1_02.dbf
       462,843      11    2.2     1.1       77,747        2        830    2.3

TBL_I_P05                /prod01/u02/oradata/HPRD1/tbl_i_p05_HPRD1_01.dbf
        72,668       2    2.3     1.1       12,468        0        505    2.2
                         /prod01/u02/oradata/HPRD1/tbl_i_p05_HPRD1_02.dbf
        75,645       2    2.5     1.1       14,021        0        540    1.9

TBL_I_P06                /prod01/u03/oradata/HPRD1/tbl_i_p06_HPRD1_01.dbf
       461,262      11    1.9     1.1       76,269        2         17   17.1
                         /prod01/u03/oradata/HPRD1/tbl_i_p06_HPRD1_02.dbf
       481,339      11    1.9     1.1       75,654        2         22    5.9

TBL_I_P07                /prod01/u04/oradata/HPRD1/tbl_i_p07_HPRD1_01.dbf
       139,572       3    2.3     1.1       26,155        1        135    4.2
                         /prod01/u04/oradata/HPRD1/tbl_i_p07_HPRD1_02.dbf
       153,373       4    2.2     1.1       27,884        1        114    4.6

TBL_I_P08                /prod01/u01/oradata/HPRD1/tbl_i_p08_HPRD1_01.dbf
       401,738       9    2.1     1.1       83,041        2        440    2.1
                         /prod01/u01/oradata/HPRD1/tbl_i_p08_HPRD1_02.dbf
       397,706       9    2.1     1.1       81,453        2        276    2.1

TBL_I_P09                /prod01/u02/oradata/HPRD1/tbl_i_p09_HPRD1_01.dbf
       570,115      13    2.1     1.1       90,727        2      3,997    3.7
                         /prod01/u02/oradata/HPRD1/tbl_i_p09_HPRD1_02.dbf
       618,435      15    1.9     1.1       90,371        2      3,263    4.0

TBL_I_P10                /prod01/u03/oradata/HPRD1/tbl_i_p10_HPRD1_01.dbf
       876,175      21    2.1     1.0      128,589        3        130    2.6
                         /prod01/u03/oradata/HPRD1/tbl_i_p10_HPRD1_02.dbf
       833,901      20    2.1     1.0      126,575        3        106    5.0

TBL_I_P11                /prod01/u04/oradata/HPRD1/tbl_i_p11_HPRD1_01.dbf
       276,832       6    2.3     1.1       58,881        1      1,089    2.7
                         /prod01/u04/oradata/HPRD1/tbl_i_p11_HPRD1_02.dbf
       292,874       7    2.2     1.1       58,350        1      1,100    2.5

TBL_I_P12                /prod01/u01/oradata/HPRD1/tbl_i_p12_HPRD1_01.dbf
       249,844       6    2.0     1.0       32,337        1      1,042    1.3
                         /prod01/u01/oradata/HPRD1/tbl_i_p12_HPRD1_02.dbf
       253,412       6    2.0     1.0       31,853        1      1,328    1.3

TBL_I_P13                /prod01/u02/oradata/HPRD1/tbl_i_p13_HPRD1_01.dbf
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
        60,331       1    2.6     1.1       11,124        0          2    5.0
TBL_I_P13                /prod01/u02/oradata/HPRD1/tbl_i_p13_HPRD1_02.dbf
        69,219       2    2.4     1.1       11,350        0          4    5.0

TBL_I_P14                /prod01/u03/oradata/HPRD1/tbl_i_p14_HPRD1_01.dbf
     1,202,161      28    1.7     1.1      113,516        3     11,949    3.1
                         /prod01/u03/oradata/HPRD1/tbl_i_p14_HPRD1_02.dbf
     1,203,267      28    1.7     1.0      119,950        3     13,468    2.6

TBL_I_P15                /prod01/u04/oradata/HPRD1/tbl_i_p15_HPRD1_01.dbf
       292,594       7    1.9     1.1       46,171        1         18    7.8
                         /prod01/u04/oradata/HPRD1/tbl_i_p15_HPRD1_02.dbf
       280,776       7    1.9     1.1       48,558        1         17    3.5

TBL_I_P16                /prod01/u01/oradata/HPRD1/tbl_i_p16_HPRD1_01.dbf
       549,507      13    1.9     1.0       76,538        2      1,320    4.1
                         /prod01/u01/oradata/HPRD1/tbl_i_p16_HPRD1_02.dbf
       536,427      13    1.9     1.0       75,077        2      1,228    4.9

TBL_I_P17                /prod01/u02/oradata/HPRD1/tbl_i_p17_HPRD1_01.dbf
       309,891       7    2.3     1.1       53,336        1         39    3.3
                         /prod01/u02/oradata/HPRD1/tbl_i_p17_HPRD1_02.dbf
       305,776       7    2.3     1.1       54,624        1         42    1.9

TBL_I_P18                /prod01/u03/oradata/HPRD1/tbl_i_p18_HPRD1_01.dbf
       519,166      12    2.2     1.0       87,431        2        697    5.4
                         /prod01/u03/oradata/HPRD1/tbl_i_p18_HPRD1_02.dbf
       507,774      12    2.2     1.0       78,909        2        714    4.8

TBL_I_P19                /prod01/u04/oradata/HPRD1/tbl_i_p19_HPRD1_01.dbf
     1,491,938      35    1.8     1.2      131,498        3     12,533    2.5
                         /prod01/u04/oradata/HPRD1/tbl_i_p19_HPRD1_02.dbf
     1,499,275      35    1.9     1.2      143,040        3     11,914    2.6

TBL_I_P20                /prod01/u01/oradata/HPRD1/tbl_i_p20_HPRD1_01.dbf
        54,068       1    2.5     1.1       11,547        0          6    6.7
                         /prod01/u01/oradata/HPRD1/tbl_i_p20_HPRD1_02.dbf
        52,828       1    2.6     1.1       10,679        0         13    6.9

TBL_I_P21                /prod01/u02/oradata/HPRD1/tbl_i_p21_HPRD1_01.dbf
       235,448       6    2.1     1.0       33,745        1      2,163    2.5
                         /prod01/u02/oradata/HPRD1/tbl_i_p21_HPRD1_02.dbf
       240,527       6    2.0     1.0       34,140        1      1,683    3.9

TBL_I_P22                /prod01/u03/oradata/HPRD1/tbl_i_p22_HPRD1_01.dbf
       111,249       3    2.3     1.1       21,828        1         28    3.2
                         /prod01/u03/oradata/HPRD1/tbl_i_p22_HPRD1_02.dbf
       123,661       3    2.1     1.1       20,204        0         67    2.7

TBL_I_P23                /prod01/u04/oradata/HPRD1/tbl_i_p23_HPRD1_01.dbf
       415,550      10    2.1     1.0       82,210        2      1,093    4.3
                         /prod01/u04/oradata/HPRD1/tbl_i_p23_HPRD1_02.dbf
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
       415,071      10    2.1     1.0       88,333        2      1,811    3.4

TBL_I_P24                /prod01/u01/oradata/HPRD1/tbl_i_p24_HPRD1_01.dbf
        78,323       2    2.7     1.1       16,991        0          5    8.0
                         /prod01/u01/oradata/HPRD1/tbl_i_p24_HPRD1_02.dbf
        76,943       2    2.7     1.1       15,213        0          6    5.0

TBL_I_1                  /prod01/u01/oradata/HPRD1/tbl_i_1_HPRD1_01.dbf
     1,299,422      30    1.5     1.2      114,613        3      1,697    2.0
                         /prod01/u01/oradata/HPRD1/tbl_i_1_HPRD1_05.dbf
     1,273,185      30    1.5     1.2      131,300        3      2,306    1.4
                         /prod01/u01/oradata/HPRD1/tbl_i_1_HPRD1_09.dbf
     1,297,655      30    1.5     1.2      104,721        2      1,970    1.9
                         /prod01/u01/oradata/HPRD1/tbl_i_1_HPRD1_13.dbf
     1,370,029      32    1.4     1.2      102,066        2      2,281    1.8
                         /prod01/u02/oradata/HPRD1/tbl_i_1_HPRD1_02.dbf
     1,293,832      30    1.4     1.1       84,567        2      2,238    1.6
                         /prod01/u02/oradata/HPRD1/tbl_i_1_HPRD1_06.dbf
     1,353,132      32    1.4     1.2       89,245        2      2,329    1.7
                         /prod01/u02/oradata/HPRD1/tbl_i_1_HPRD1_10.dbf
     1,450,520      34    1.4     1.2      130,850        3      2,466    1.6
                         /prod01/u02/oradata/HPRD1/tbl_i_1_HPRD1_14.dbf
     1,198,234      28    1.4     1.2       63,609        1      3,105    1.2
                         /prod01/u03/oradata/HPRD1/tbl_i_1_HPRD1_03.dbf
     1,385,458      33    1.4     1.2      147,131        3      2,394    1.8
                         /prod01/u03/oradata/HPRD1/tbl_i_1_HPRD1_07.dbf
     1,326,083      31    1.4     1.2      115,070        3      1,564    2.0
                         /prod01/u03/oradata/HPRD1/tbl_i_1_HPRD1_11.dbf
     1,470,646      35    1.3     1.2      125,803        3      2,871    1.2
                         /prod01/u03/oradata/HPRD1/tbl_i_1_HPRD1_15.dbf
       912,818      21    1.4     1.2       45,216        1      1,584    1.5
                         /prod01/u04/oradata/HPRD1/tbl_i_1_HPRD1_04.dbf
     1,375,624      32    1.4     1.2      157,222        4      2,694    1.5
                         /prod01/u04/oradata/HPRD1/tbl_i_1_HPRD1_08.dbf
     1,446,323      34    1.3     1.2      146,621        3      3,396    1.4
                         /prod01/u04/oradata/HPRD1/tbl_i_1_HPRD1_12.dbf
     1,438,526      34    1.2     1.2      102,518        2      3,580    1.1
                         /prod01/u04/oradata/HPRD1/tbl_i_1_HPRD1_16.dbf
       810,244      19    1.4     1.2       41,967        1      1,277    1.6

TEMP                     /prod01/u09/oradata/HPRD1/temp_HPRD1_01.dbf
       645,781      15    0.8    18.5      322,999        8          0
                         /prod01/u09/oradata/HPRD1/temp_HPRD1_02.dbf
     1,393,207      33    1.1    16.1      599,415       14          0

TOOLS                    /prod01/u01/oradata/HPRD1/tools_HPRD1_01.dbf
         3,158       0    1.6     2.5        1,811        0          0

UNDOTBS1                 /prod01/u08/oradata/HPRD1/undotbs_HPRD1_01.dbf
        14,966       0    1.8     1.0    1,544,831       36      1,901    3.9
                         /prod01/u09/oradata/HPRD1/undotbs_HPRD1_02.dbf
         9,459       0    3.6     1.0    1,472,325       35        429    0.1
File IO Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->ordered by Tablespace, File

Tablespace               Filename
------------------------ ----------------------------------------------------
                 Av      Av     Av                    Av        Buffer Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------

          -------------------------------------------------------------
Buffer Pool Statistics for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> Standard block size Pools  D: default,  K: keep,  R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

                                                           Free    Write  Buffer
     Number of Cache      Buffer    Physical   Physical  Buffer Complete    Busy
P      Buffers Hit %        Gets       Reads     Writes   Waits    Waits   Waits
--- ---------- ----- ----------- ----------- ---------- ------- --------  ------
D    1,270,400  96.2############ 307,506,919 10,063,507       0        8########
          -------------------------------------------------------------

Instance Recovery Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> B: Begin snapshot,  E: End snapshot

  Targt Estd                                    Log File   Log Ckpt   Log Ckpt
  MTTR  MTTR   Recovery    Actual     Target      Size     Timeout    Interval
   (s)   (s)   Estd IOs  Redo Blks  Redo Blks  Redo Blks  Redo Blks  Redo Blks
- ----- ----- ---------- ---------- ---------- ---------- ---------- ----------
B   300    42      36701     472169     471852     471852    1424346
E   300    33      27161     471311     471852     471852    1492014
          -------------------------------------------------------------

Buffer Pool Advisory for DB: HPRD1  Instance: HPRD1  End Snap: 46994
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate (default block size first)

        Size for  Size      Buffers for  Est Physical          Estimated
P   Estimate (M) Factr         Estimate   Read Factor     Physical Reads
--- ------------ ----- ---------------- ------------- ------------------
D          1,024    .1          127,040          4.55      1,402,283,218
D          2,048    .2          254,080          3.32      1,023,430,682
D          3,072    .3          381,120          2.69        828,433,741
D          4,096    .4          508,160          2.27        700,194,143
D          5,120    .5          635,200          1.95        600,470,309
D          6,144    .6          762,240          1.69        521,137,325
D          7,168    .7          889,280          1.47        452,907,299
D          8,192    .8        1,016,320          1.29        397,546,222
D          9,216    .9        1,143,360          1.14        350,132,448
D         10,240   1.0        1,270,400          1.00        308,073,336
D         11,264   1.1        1,397,440          0.90        276,095,092
D         12,288   1.2        1,524,480          0.81        250,088,864
D         13,312   1.3        1,651,520          0.74        229,061,582
D         14,336   1.4        1,778,560          0.68        210,699,681
D         15,360   1.5        1,905,600          0.63        194,856,030
D         16,384   1.6        2,032,640          0.59        181,630,400
D         17,408   1.7        2,159,680          0.55        170,099,228
D         18,432   1.8        2,286,720          0.52        159,852,933
D         19,456   1.9        2,413,760          0.49        151,138,334
D         20,480   2.0        2,540,800          0.47        143,538,320
          -------------------------------------------------------------


Buffer wait Statistics for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> ordered by wait time desc, waits desc

                                 Tot Wait    Avg
Class                    Waits   Time (s) Time (ms)
------------------ ----------- ---------- ---------
data block           1,105,129      1,664         2
undo header              1,454          7         5
1st level bmb               49          0         5
3rd level bmb               21          0         8
undo block                 876          0         0
2nd level bmb               52          0         2
file header block            2          0        50
segment header              18          0         3
extent map                   2          0        10
          -------------------------------------------------------------
PGA Aggr Target Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> B: Begin snap   E: End snap (rows dentified with B or E contain data
   which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used    - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem    - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem   - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem    - percentage of workarea memory under manual control

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ---------------- -------------------------
           98.0          788,504                    16,347

                                             %PGA  %Auto   %Man
  PGA Aggr  Auto PGA   PGA Mem    W/A PGA    W/A    W/A    W/A   Global Mem
  Target(M) Target(M)  Alloc(M)   Used(M)    Mem    Mem    Mem    Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B     4,096     3,648      357.3        7.0    2.0  100.0     .0    102,400
E     4,096     3,668       62.3        0.3     .5  100.0     .0    102,400
          -------------------------------------------------------------

PGA Aggr Target Histogram for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> Optimal Executions are purely in-memory operations

    Low    High
Optimal Optimal    Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
     2K      4K     16,486,041    16,486,041            0            0
     4K      8K        456,502       456,502            0            0
     8K     16K        328,499       328,499            0            0
    16K     32K        213,317       213,317            0            0
    32K     64K        124,186       124,186            0            0
    64K    128K         42,449        42,449            0            0
   128K    256K         11,373        11,373            0            0
   256K    512K         14,374        14,374            0            0
   512K   1024K        315,135       315,135            0            0
     1M      2M        235,314       235,314            0            0
     2M      4M         11,004        11,004            0            0
     4M      8M            674           674            0            0
     8M     16M            453           453            0            0
    16M     32M            236           236            0            0
    32M     64M            208           208            0            0
    64M    128M            123           115            6            2
   128M    256M            905           904            1            0
   256M    512M             16             0           16            0
   512M   1024M             13             0           13            0
          -------------------------------------------------------------

PGA Memory Advisory for DB: HPRD1  Instance: HPRD1  End Snap: 46994
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
   where Estd PGA Overalloc Count is 0

                                       Estd Extra    Estd PGA   Estd PGA
PGA Target    Size           W/A MB   W/A MB Read/      Cache  Overalloc
  Est (MB)   Factr        Processed Written to Disk     Hit %      Count
---------- ------- ---------------- ---------------- -------- ----------
       512     0.1        885,576.2        251,584.5     78.0      1,303
     1,024     0.3        885,576.2         97,014.2     90.0          0
     2,048     0.5        885,576.2         87,605.3     91.0          0
     3,072     0.8        885,576.2         87,605.3     91.0          0
     4,096     1.0        885,576.2         15,695.2     98.0          0
     4,915     1.2        885,576.2         15,346.0     98.0          0
     5,734     1.4        885,576.2         15,346.0     98.0          0
     6,554     1.6        885,576.2         15,346.0     98.0          0
     7,373     1.8        885,576.2         15,346.0     98.0          0
     8,192     2.0        885,576.2         15,346.0     98.0          0
    12,288     3.0        885,576.2         15,346.0     98.0          0
    16,384     4.0        885,576.2         15,346.0     98.0          0
    24,576     6.0        885,576.2         15,346.0     98.0          0
    32,768     8.0        885,576.2         15,346.0     98.0          0
          -------------------------------------------------------------
Enqueue activity for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> Enqueue stats gathered prior to 9i should not be compared with 9i data
-> ordered by Wait Time desc, Waits desc

                                                        Avg Wt         Wait
Eq     Requests    Succ Gets Failed Gets       Waits   Time (ms)     Time (s)
-- ------------ ------------ ----------- ----------- ------------- ------------
TX    1,762,084    1,761,683         429         431      6,729.30        2,900
CF       31,118       31,116           2           5      1,257.00            6
SQ       71,224       71,224           0         694          2.54            2
TC           25           25           0           5        300.20            2
PS       13,320       10,705       2,615         864           .07            0
CU    1,239,144    1,239,154           0          17          3.41            0
US       48,651       48,651           0           2           .50            0
          -------------------------------------------------------------
Rollback Segment Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->A high value for "Pct Waits" suggests more rollback segments may be required
->RBS stats may not be accurate between begin and end snaps when using Auto Undo
  managment, as RBS may be dynamically created and dropped as needed

        Trans Table       Pct   Undo Bytes
RBS No      Gets        Waits     Written        Wraps  Shrinks  Extends
------ -------------- ------- --------------- -------- -------- --------
     0          549.0    0.00           9,850        0        0        0
     1    1,574,368.0    0.01   1,737,270,862      263       17      232
     2    1,032,178.0    0.02   2,358,101,246      422       43      303
     3      707,315.0    0.01   1,945,218,882      214       19      146
     4      617,035.0    0.03   1,597,490,100      231       31      190
     5      517,196.0    0.01   1,027,776,310      165       17      102
     6      431,792.0    0.01     753,283,636      114       12       78
     7      298,981.0    0.01     592,741,542      127        9       53
     8      322,358.0    0.01     855,519,710      127        5       58
     9      158,948.0    0.00     287,487,242       56        8       27
    10      215,371.0    0.00     334,155,620       51        3       19
    11      146,777.0    0.02     199,982,412       35        8        1
    12       94,413.0    0.00     142,632,350       54        2       27
    13      192,563.0    0.00     625,304,590       98        7       60
    14      153,752.0    0.01     563,289,690       82        7       52
          -------------------------------------------------------------
Rollback Segment Storage for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->Optimal Size should be larger than Avg Active

RBS No    Segment Size      Avg Active    Optimal Size    Maximum Size
------ --------------- --------------- --------------- ---------------
     0       1,384,448               0                       1,384,448
     1     185,720,832      77,883,133                   4,270,972,928
     2     755,097,600      72,108,821                   1,142,022,144
     3     410,116,096      52,058,766                   1,502,732,288
     4     260,169,728      26,502,095                   1,140,973,568
     5     433,184,768      20,503,263                     641,851,392
     6     369,221,632      32,173,516                     536,993,792
     7     250,732,544     104,638,151                     293,724,160
     8     320,987,136     173,624,221                     411,164,672
     9     120,709,120       9,729,744                     267,509,760
    10      92,397,568      60,622,551                     276,946,944
    11     111,271,936       8,109,430                     502,390,784
    12      85,057,536       4,410,884                     100,786,176
    13     236,052,480      98,683,758                     444,719,104
    14     201,449,472      96,641,762                     427,941,888
          -------------------------------------------------------------
Undo Segment Summary for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> Undo segment block stats:
-> uS - unexpired Stolen,   uR - unexpired Released,   uU - unexpired reUsed
-> eS - expired   Stolen,   eR - expired   Released,   eU - expired   reUsed

Undo           Undo        Num  Max Qry     Max Tx Snapshot Out of uS/uR/uU/
 TS#         Blocks      Trans  Len (s)   Concurcy  Too Old  Space eS/eR/eU
---- -------------- ---------- -------- ---------- -------- ------ -------------
   3      3,052,946 ##########    4,554         15        0      0 0/0/0/0/0/0
          -------------------------------------------------------------


Undo Segment Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> ordered by Time desc

                     Undo      Num Max Qry   Max Tx  Snap   Out of uS/uR/uU/
End Time           Blocks    Trans Len (s)    Concy Too Old  Space eS/eR/eU
------------ ------------ -------- ------- -------- ------- ------ -------------
11-Sep 19:02       80,882 ########     532        2       0      0 0/0/0/0/0/0
11-Sep 18:52       62,592 ########     260        3       0      0 0/0/0/0/0/0
11-Sep 18:42       72,875 ########     667        1       0      0 0/0/0/0/0/0
11-Sep 18:32       64,397 ########     210        2       0      0 0/0/0/0/0/0
11-Sep 18:22       88,861 ########     171        1       0      0 0/0/0/0/0/0
11-Sep 18:12       41,259 ########     120        2       0      0 0/0/0/0/0/0
11-Sep 18:02       38,618 ########     120        2       0      0 0/0/0/0/0/0
11-Sep 17:52       71,919 ########     178        1       0      0 0/0/0/0/0/0
11-Sep 17:42       71,946 ########     379        4       0      0 0/0/0/0/0/0
11-Sep 17:32      123,008 ########     336        5       0      0 0/0/0/0/0/0
11-Sep 17:22       58,898 ########     415        4       0      0 0/0/0/0/0/0
11-Sep 17:12       61,109 ########     456        3       0      0 0/0/0/0/0/0
11-Sep 17:02       74,566 ########     434        3       0      0 0/0/0/0/0/0
11-Sep 16:52       67,987 ########     500        3       0      0 0/0/0/0/0/0
11-Sep 16:42       21,621 ########     457        4       0      0 0/0/0/0/0/0
11-Sep 16:32       10,156 ########     363        4       0      0 0/0/0/0/0/0
11-Sep 16:22       14,775 ########     500        8       0      0 0/0/0/0/0/0
11-Sep 16:12       15,734 ########     945        6       0      0 0/0/0/0/0/0
11-Sep 16:02       15,198 ########     885        9       0      0 0/0/0/0/0/0
11-Sep 15:52       12,279 ########     809        3       0      0 0/0/0/0/0/0
11-Sep 15:42       20,711 ########     359        6       0      0 0/0/0/0/0/0
11-Sep 15:32       18,550 ########     343        5       0      0 0/0/0/0/0/0
11-Sep 15:22       14,527 ########     384        9       0      0 0/0/0/0/0/0
11-Sep 15:12       22,475 ########     549        5       0      0 0/0/0/0/0/0
11-Sep 15:02       22,135 ########     616        4       0      0 0/0/0/0/0/0
11-Sep 14:52       12,072 ########     509       11       0      0 0/0/0/0/0/0
11-Sep 14:42       12,856 ########     544        7       0      0 0/0/0/0/0/0
11-Sep 14:32       11,645 ########     321        4       0      0 0/0/0/0/0/0
11-Sep 14:22       14,710 ########     325        3       0      0 0/0/0/0/0/0
11-Sep 14:12       41,560 ########     639       12       0      0 0/0/0/0/0/0
11-Sep 14:02       61,519 ########     520        6       0      0 0/0/0/0/0/0
11-Sep 13:52       70,710 ########   1,825        9       0      0 0/0/0/0/0/0
11-Sep 13:42       44,753 ########   1,816        9       0      0 0/0/0/0/0/0
11-Sep 13:32       68,223 ########   1,279       15       0      0 0/0/0/0/0/0
          -------------------------------------------------------------
Latch Activity for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
  willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                              Get          Get   Slps   Time       NoWait NoWait
Latch                       Requests      Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
active checkpoint queue       1,880,127    0.0             0            2    0.0
alert log latch                     697    0.0             0            2    0.0
archive control                   4,818    0.0             0            0
archive process latch             1,647    1.4    0.2      0            0
cache buffer handles        138,993,723    0.6    0.0      0            0
cache buffers chains     ##############    0.2    0.0    289  435,835,777    0.0
cache buffers lru chain      24,288,858    0.2    0.0      2  433,885,841    0.3
channel handle pool latc        213,948    0.0    0.0      0            0
channel operations paren        567,146    0.1    0.0      0            0
checkpoint queue latch    1,634,198,933    0.0    0.0      0    9,554,033    0.0
child cursor hash table      47,262,585    0.0    0.0      0            0
commit callback allocati        160,632    0.0             0            0
Consistent RBA                  528,172    0.0    0.0      0            0
constraint object alloca        102,994    0.0    0.0      0            0
dictionary lookup                   174    0.0             0            0
dml lock allocation           8,215,295    0.0    0.0      0            0
dummy allocation                111,077    0.3    0.0      0            0
enqueue hash chains          36,136,138    0.0    0.0      0            0
enqueues                     34,035,607    0.1    0.0      0            0
error message lists               4,839    1.9    0.0      0            0
event group latch                52,773    0.0             0            0
FAL request queue                   851    0.0             0            0
FAL subheap alocation                 0                    0            2    0.0
FIB s.o chain latch               5,441    0.0             0            0
FOB s.o list latch              613,844    0.5    0.0      0            0
global tx hash mapping           10,659    0.0             0            0
hash table column usage          13,321    0.0    0.5      0  296,605,493    0.0
hash table modification           3,927    0.0             0            2    0.0
internal temp table obje              3    0.0             0            0
i/o slave adaptor                     0                    0            2    0.0
job workq parent latch                0                    0          190    3.7
job_queue_processes para            805    0.0             0            2    0.0
ksfv messages                         0                    0            4    0.0
ktm global data                  51,751    0.0             0            0
lgwr LWN SCN                    529,626    0.0    0.0      0            0
library cache               711,687,089    0.2    0.0     21    2,209,456    0.9
library cache load lock          48,970    0.0             0            0
library cache pin           455,699,787    0.0    0.0      0            0
library cache pin alloca    181,277,767    0.0    0.0      0            0
list of block allocation        879,891    0.0    0.0      0            0
loader state object free         32,210    0.0    0.0      0            0
longop free list parent           1,227    0.0             0        1,039    0.0
message pool operations         108,678    0.0    0.1      0            0
messages                      7,116,946    0.0    0.0      0            0
mostly latch-free SCN           534,416    0.3    0.0      0            0
multiblock read objects      43,387,984    0.1    0.0      0            2    0.0
name-service namespace o              0                    0            2    0.0
ncodef allocation latch             676    0.0             0            0
non-pers queues instance              0                    0            2    0.0
object stats modificatio         18,890    0.0    0.0      0            2    0.0
Latch Activity for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
  willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

                                           Pct    Avg   Wait                 Pct
                              Get          Get   Slps   Time       NoWait NoWait
Latch                       Requests      Miss  /Miss    (s)     Requests   Miss
------------------------ -------------- ------ ------ ------ ------------ ------
parallel query alloc buf         70,887    2.3    0.0      0            0
parallel query stats              4,280    7.7    0.0      0            0
post/wait queue                 628,751    0.0    0.0      0      337,694    0.0
process allocation              105,584    0.1    0.0      0       52,753    0.0
process group creation          105,584    0.0    0.0      0            0
process queue                    14,941    1.1    0.0      0            0
process queue reference       5,370,912    0.0    0.0      0      376,879    0.1
query server freelists           20,683    1.7    0.0      0            0
query server process                  5    0.0             0            5    0.0
redo allocation             100,216,118    0.1    0.0      0            0
redo copy                             0                    0   99,311,728    0.0
redo writing                  3,493,795    0.0    0.0      0            0
resumable state object               11    0.0             0            0
row cache enqueue latch     503,850,084    0.6    0.0      0            0
row cache objects           537,222,229    0.1    0.0      0       74,430    0.1
sequence cache               18,358,256    0.0    0.0      0            0
session allocation           54,302,815    0.1    0.0      0            0
session idle bit            382,188,322    0.0    0.0      3            0
session switching                   676    0.0             0            0
session timer                    14,194    0.0             0            0
shared pool                 323,608,740    0.2    0.0     22            0
sim partition latch                   0                    0       60,760    0.0
simulator hash latch        494,021,309    0.0    0.0      0            0
simulator lru latch          13,079,113    0.1    0.0      0   21,217,980    0.0
sort extent pool                461,459    0.0    0.0      0            0
SQL memory manager latch             71    0.0             0       14,175    0.0
SQL memory manager worka      9,995,349    0.0    0.0      0            0
temporary table state ob          2,621    0.0             0            0
TLCR meta context                    93    0.0             0            0
Token Manager                         0                    0            2    0.0
trace latch                       1,022    0.0             0            0
transaction allocation       74,263,387    0.0    0.0      0            0
transaction branch alloc          1,969    0.0             0            0
undo global data             10,896,232    0.0    0.0      0           94    0.0
user lock                       209,692    0.0    0.0      0            0
vecio buf des                         0                    0            2    0.0
          -------------------------------------------------------------
Latch Sleep breakdown for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> ordered by misses desc

                                      Get                            Spin &
Latch Name                       Requests      Misses      Sleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
cache buffers chains       ##############  23,015,227      26,193 22989103/261
                                                                  03/39/4/0
row cache enqueue latch       503,850,084   2,991,703         122 2991581/122/
                                                                  0/0/0
library cache                 711,687,089   1,115,130      17,962 1097225/1785
                                                                  2/51/2/0
cache buffer handles          138,993,723     860,732          59 860673/59/0/
                                                                  0/0
shared pool                   323,608,740     625,725      13,382 612541/13012
                                                                  /150/22/0
row cache objects             537,222,229     427,065         117 426948/117/0
                                                                  /0/0
redo allocation               100,216,118     125,373         114 125259/114/0
                                                                  /0/0
session allocation             54,302,815      57,576         253 57323/253/0/
                                                                  0/0
cache buffers lru chain        24,288,858      50,186         892 49295/890/1/
                                                                  0/0
multiblock read objects        43,387,984      42,635          27 42608/27/0/0
                                                                  /0
library cache pin             455,699,787      41,653          74 41579/74/0/0
                                                                  /0
session idle bit              382,188,322      19,721         324 19397/324/0/
                                                                  0/0
enqueues                       34,035,607      18,844          54 18790/54/0/0
                                                                  /0
library cache pin allocati    181,277,767      13,666          52 13614/52/0/0
                                                                  /0
child cursor hash table        47,262,585      12,942           4 12938/4/0/0/
                                                                  0
checkpoint queue latch      1,634,198,933       8,501           8 8493/8/0/0/0
simulator lru latch            13,079,113       7,747          67 7680/67/0/0/
                                                                  0
simulator hash latch          494,021,309       4,616           8 4608/8/0/0/0
dml lock allocation             8,215,295       3,568          12 3556/12/0/0/
                                                                  0
messages                        7,116,946       1,592           2 1590/2/0/0/0
mostly latch-free SCN             534,416       1,381           3 1378/3/0/0/0
enqueue hash chains            36,136,138         940           2 938/2/0/0/0
channel operations parent         567,146         577           9 568/9/0/0/0
process allocation                105,584          59           2 57/2/0/0/0
user lock                         209,692          45           1 44/1/0/0/0
archive process latch               1,647          23           5 18/5/0/0/0
message pool operations pa        108,678          10           1 9/1/0/0/0
hash table column usage la         13,321           2           1 1/1/0/0/0
          -------------------------------------------------------------
Latch Miss Sources for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
archive process latch    kcrrpa                           0          5        0
cache buffer handles     kcbzgs                           0         34       42
cache buffer handles     kcbzfs                           0         25       17
cache buffers chains     kcbgtcr: kslbegin excl           0     21,459   17,335
cache buffers chains     kcbrls: kslbegin                 0      2,687    7,305
cache buffers chains     kcbgtcr: fast path               0        862      619
cache buffers chains     kcbzwb                           0        380      122
cache buffers chains     kcbgtcr: kslbegin shared         0        207      147
cache buffers chains     kcbzgb: scan from tail. no       0        121        0
cache buffers chains     kcbchg: kslbegin: bufs not       0        100      120
cache buffers chains     kcbzib: finish free bufs         0         63      295
cache buffers chains     kcbzib: multi-block read:        0         51        0
cache buffers chains     kcbgcur: kslbegin                0         43       25
cache buffers chains     kcbget: pin buffer               0         33       34
cache buffers chains     kcbchg: kslbegin: call CR        0         20       69
cache buffers chains     kcbgtcr                          0         14        0
cache buffers chains     kcbget: exchange                 0          7        0
cache buffers chains     kcbget: exchange rls             0          5        0
cache buffers chains     kcbbxsv                          0          4        2
cache buffers chains     kcbnlc                           0          4       21
cache buffers chains     kcbbic2                          0          2        1
cache buffers chains     kcbzib: exchange rls             0          2        0
cache buffers chains     kcbso1: set no access            0          2        0
cache buffers chains     kcbbic1                          0          1        3
cache buffers chains     kcbibr                           0          1        2
cache buffers chains     kcbnew                           0          1        0
cache buffers chains     kcbclc                           0          1        0
cache buffers lru chain  kcbzgb: multiple sets nowa #######        651        0
cache buffers lru chain  kcbbiop: lru scan           46,907        222      182
cache buffers lru chain  kcbzar: KSLNBEGIN           12,559          7        0
cache buffers lru chain  kcbzgb: posted for free bu     791          5      275
cache buffers lru chain  kcbzgm                       3,278          5        0
cache buffers lru chain  kcbbic2                        424          1      228
cache buffers lru chain  kcbbwlru                       251          1      159
channel operations paren ksrmfree()                       0          5        0
channel operations paren ksrapublish()                    0          3        0
channel operations paren ksrwait()                        0          1        2
checkpoint queue latch   kcbklbc: Link buffer into        0          5        0
checkpoint queue latch   kcbbwthc: thread checkpoin       0          2        0
checkpoint queue latch   kcbswcu: Switch buffers          0          1        1
child cursor hash table  kksfbc: new child                0          1        2
child cursor hash table  kkslod: mark kksb state          0          1        1
child cursor hash table  kkslod: set opcode               0          1        0
child cursor hash table  opiaba: bitset.                  0          1        1
cost function            kzulgt: find user res            0          1        1
dml lock allocation      ktaiam                           0          7       10
dml lock allocation      ktaidm                           0          5        2
enqueue hash chains      ksqgtl3                          0          1        0
enqueue hash chains      ksqrcl                           0          1        2
enqueues                 ksqies                           0         19       40
enqueues                 ksqgel: create enqueue           0         18        8
enqueues                 ksqdel                           0         17        6
hash table column usage  KSXMMON_GETCELEM                 0          1        0
Latch Miss Sources for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
library cache            kglic                            0      5,902    1,190
library cache            kglupc: child                    0      2,212    2,680
library cache            kgllkdl: child: cleanup          0      1,923      218
library cache            kglpnc: child                    0      1,435    5,183
library cache            kglpin: child: heap proces       0      1,102       74
library cache            kglpndl: child: before pro       0        979    1,704
library cache            kgldte: child 0                  0        709    1,264
library cache            kglobpn: child:                  0        532      198
library cache            kglhdgn: child:                  0        424    4,263
library cache            kglhdgc: child:                  0        150       88
library cache            kglpndl: child: after proc       0        116       20
library cache            kglpnp: child                    0        101      571
library cache            kglpin                           0         56       93
library cache            kgldti: 2child                   0         54       92
library cache            kglobld                          0         15       21
library cache            kglhdiv: child                   0         13        0
library cache            kglget: child: KGLDSBRD          0         12      106
library cache            kglget: child: KGLDSBYD          0          1       85
library cache            kglhfr: child                    0          1        0
library cache pin        kglpnc: child                    0         23       30
library cache pin        kglpndl                          0         22        6
library cache pin        kglupc                           0         15       18
library cache pin        kglpnal: child: alloc spac       0         12       18
library cache pin        kglpnp: child                    0          2        2
library cache pin alloca kglpnal                          0         42       22
library cache pin alloca kgllkdl                          0         10       31
message pool operations  ksrmfree()                       0          1        0
messages                 ksaamb: after wakeup             0          1        0
messages                 ksarcv: after wait               0          1        0
mostly latch-free SCN    kcslcu3                          0          3        3
multiblock read objects  kcbzib: normal mbr free          0         14        6
multiblock read objects  kcbzib: mbr get                  0         13       21
process allocation       ksucrp                           0          2        0
redo allocation          kcrfwr                           0        111      101
redo allocation          kcrfwi: more space               0          3       12
row cache enqueue latch  kqreqd                           0         72       17
row cache enqueue latch  kqreqa                           0         50      106
row cache objects        kqrpfl: not dirty                0         79        2
row cache objects        kqrpre: find obj                 0         32      115
row cache objects        kqrso                            0          3        0
row cache objects        kqrcmt: while loop               0          1        0
session allocation       ksufap: active sessions          0         85        0
session allocation       ksucri                           0         82      179
session allocation       ksuxds: not user session         0         47       21
session allocation       ksuprc                           0         25       35
session allocation       ksudlc                           0          5       12
session allocation       ksudlp                           0          4        1
session allocation       ksuxds: KSUSFCLC not set         0          4        4
session allocation       ksucrp                           0          1        1
session idle bit         ksupuc: set busy                 0        244      107
session idle bit         ksupuc: clear busy               0         71      200
session idle bit         ksuxds                           0          9       17
shared pool              kghalo                           0      5,258    2,024
Latch Miss Sources for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

                                                     NoWait              Waiter
Latch Name               Where                       Misses     Sleeps   Sleeps
------------------------ -------------------------- ------- ---------- --------
shared pool              kghupr1                          0      3,178   10,915
shared pool              kghfrunp: alloc: wait            0      2,360        0
shared pool              kghfrunp: clatch: nowait         0      2,022        0
shared pool              kghdmp                           0      1,376        0
shared pool              kghalp                           0      1,091      197
shared pool              kghfrunp: clatch: wait           0        205      113
shared pool              kghfre                           0        101      227
shared pool              kghfen: not perm alloc cla       0         18       23
simulator hash latch     kcbsacc: lookup dba              0          7        7
simulator hash latch     kcbs_lookup_setid: lookup        0          1        0
simulator lru latch      kcbs_simulate: simulate se       0         67       67
          -------------------------------------------------------------
Dictionary Cache Stats for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->"Pct Misses"  should be very low (< 2% in most cases)
->"Cache Usage" is the number of cache entries being used
->"Pct SGA"     is the ratio of usage to allocated size for that cache

                                   Get    Pct    Scan   Pct      Mod      Final
Cache                         Requests   Miss    Reqs  Miss     Reqs      Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_database_links                3,430    0.0       0              0          2
dc_files                     1,152,774    0.0       0              0        147
dc_global_oids                       4   50.0       0              0          2
dc_histogram_data           29,320,507    0.0       0         13,068     13,204
dc_histogram_data_values        73,117    0.0       0              0         55
dc_histogram_defs           34,434,223    0.1       0          2,320     26,981
dc_object_ids              141,082,841    0.0       0              3      2,749
dc_objects                   3,500,982    0.2       0            165      3,903
dc_profiles                     55,924    0.0       0              0          2
dc_rollback_segments           110,434    0.0       0             37        178
dc_segments                 17,725,080    0.1       0            815      3,452
dc_sequences                   765,850    0.0       0        765,850         21
dc_table_scns                   46,160    0.0       0              0          1
dc_tablespace_quotas               710   19.0       0            665         27
dc_tablespaces              17,034,785    0.0       0              0         64
dc_user_grants                 564,346    0.0       0              0         22
dc_usernames                   203,184    0.0       0              0         14
dc_users                    36,034,687    0.0       0              0         24
          -------------------------------------------------------------


Library Cache Activity for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994
->"Pct Misses"  should be very low

                         Get  Pct        Pin        Pct               Invali-
Namespace           Requests  Miss     Requests     Miss     Reloads  dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY                  34,519    0.1         34,539    0.2         41        0
CLUSTER                8,939    0.2          5,104    0.5          0        0
INDEX             18,080,171    0.0     10,453,275    0.0          0        0
SQL AREA          33,085,312    1.8    172,059,344    0.9    193,306    7,509
TABLE/PROCEDURE    7,348,977    0.0     49,591,205    0.0     14,383        0
TRIGGER              172,710    0.0        172,710    0.0          3        0
          -------------------------------------------------------------
Shared Pool Advisory for DB: HPRD1  Instance: HPRD1  End Snap: 46994
-> Note there is often a 1:Many correlation between a single logical object
   in the Library Cache, and the physical number of memory objects associated
   with it.  Therefore comparing the number of Lib Cache objects (e.g. in
   v$librarycache), with the number of Lib Cache Memory Objects is invalid

                                                          Estd
Shared Pool    SP       Estd         Estd     Estd Lib LC Time
   Size for  Size  Lib Cache    Lib Cache   Cache Time   Saved  Estd Lib Cache
  Estim (M) Factr   Size (M)      Mem Obj    Saved (s)   Factr    Mem Obj Hits
----------- ----- ---------- ------------ ------------ ------- ---------------
      1,616    .5      1,641       77,733      309,672     1.0     109,782,322
      1,936    .6      1,959       90,727      310,072     1.0     109,869,301
      2,256    .7      2,275      102,825      310,326     1.0     109,981,865
      2,576    .8      2,592      115,005      310,514     1.0     110,097,824
      2,896    .9      2,910      127,463      310,645     1.0     110,188,721
      3,216   1.0      3,227      140,813      310,753     1.0     110,261,815
      3,536   1.1      3,546      154,689      310,852     1.0     110,321,407
      3,856   1.2      3,865      169,086      310,929     1.0     110,371,490
      4,176   1.3      4,183      183,428      311,001     1.0     110,414,520
      4,496   1.4      4,521      199,737      311,053     1.0     110,450,039
      4,816   1.5      4,838      213,286      311,105     1.0     110,481,641
      5,136   1.6      5,156      227,776      311,143     1.0     110,507,859
      5,456   1.7      5,511      242,932      311,184     1.0     110,531,184
      5,776   1.8      5,830      258,079      311,216     1.0     110,551,408
      6,096   1.9      6,149      272,692      311,242     1.0     110,569,131
      6,416   2.0      6,848      307,115      311,263     1.0     110,584,705
          -------------------------------------------------------------
SGA Memory Summary for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

SGA regions                       Size in Bytes
------------------------------ ----------------
Database Buffers                 10,737,418,240
Fixed Size                              764,896
Redo Buffers                          2,633,728
Variable Size                     6,442,450,944
                               ----------------
sum                              17,183,267,808
          -------------------------------------------------------------


SGA breakdown difference for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

Pool   Name                                Begin value        End value  % Diff
------ ------------------------------ ---------------- ---------------- -------
java   free memory                          33,554,432       33,554,432    0.00
large  free memory                          16,777,216       16,777,216    0.00
shared alter system errs: kspnfy               110,592          110,592    0.00
shared branch                                  944,152          944,152    0.00
shared channel handle                          624,592          624,592    0.00
shared character set object                    234,896          127,416  -45.76
shared Checkpoint queue                     24,606,720       24,606,720    0.00
shared constraints                             658,568          658,568    0.00
shared db_block_hash_buckets                78,401,872       78,401,872    0.00
shared db_handles                            2,784,000        2,784,000    0.00
shared dictionary cache                      4,274,432        4,274,432    0.00
shared enqueue                               4,881,224        4,881,224    0.00
shared enqueue resources                       745,296          790,912    6.12
shared enqueue_hash                            255,600          255,600    0.00
shared errors                                   29,472           57,472   95.01
shared event statistics per sess            30,068,360       30,068,360    0.00
shared FileIdentificatonBlock                  449,664          449,664    0.00
shared FileOpenBlock                        14,425,520       14,425,520    0.00
shared fixed allocation callback                 4,576            4,576    0.00
shared free memory                       2,944,550,896    1,476,547,296  -49.85
shared joxs heap init                            4,240            4,240    0.00
shared KGK heap                                 13,400           13,400    0.00
shared KGLS heap                            10,234,760        9,984,992   -2.44
shared kglsim hash table bkts                4,194,304        4,194,304    0.00
shared kglsim heap                           1,834,560       19,061,120  939.00
shared kglsim object batch                   3,765,888       42,590,016 #######
shared kglsim sga                              137,544          137,544    0.00
shared KQR L PO                             21,046,592        6,958,312  -66.94
shared KQR L SO                                112,640          112,640    0.00
shared KQR M PO                             30,023,432       16,038,240  -46.58
shared KQR M SO                             12,565,080        6,762,368  -46.18
shared KQR S SO                                  4,104            5,640   37.43
shared KQR X PO                                  5,152            7,728   50.00
shared krvxrr                                  253,056          253,056    0.00
shared ksm_file2sga region                     370,496          370,496    0.00
shared ksuloi: long op statistic               124,000          124,000    0.00
shared KSXR pending messages que               853,952          853,952    0.00
shared KSXR receive buffers                  1,034,000        1,034,000    0.00
shared ktlbk state objects                   1,559,224        1,559,224    0.00
shared latch nowait fails or sle                67,648           67,648    0.00
shared library cache                        80,279,592      386,701,016  381.69
shared log_buffer                               81,952           81,952    0.00
shared message pool freequeue                  732,208          499,864  -31.73
shared messages                                499,200          499,200    0.00
shared miscellaneous                         8,414,584       41,186,544  389.47
shared MS alert log                             72,704           72,704    0.00
shared MTTR advisory                           563,584          631,936   12.13
shared obj htab chunk                          625,128          655,872    4.92
shared parameters                              106,776          242,464  127.08
shared partitioning d                        6,976,080        6,513,816   -6.63
shared PLS non-lib hp                            2,088            2,088    0.00
shared PL/SQL DIANA                          1,591,928        2,454,328   54.17
shared PL/SQL MPCODE                         1,880,224        4,359,112  131.84
shared processes                             3,283,200        3,283,200    0.00


SGA breakdown difference for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

Pool   Name                                Begin value        End value  % Diff
------ ------------------------------ ---------------- ---------------- -------
shared qmps connections                      1,163,800        1,163,800    0.00
shared replication session stats               804,080          804,080    0.00
shared SEQ S.O.                                423,200          423,200    0.00
shared session param values                  1,258,560          391,552  -68.89
shared sessions                              7,152,080        7,152,080    0.00
shared set_descriptor_array                    304,128          304,128    0.00
shared sim hash latches                        122,880          122,880    0.00
shared sim memory hea                       10,633,112       10,633,112    0.00
shared sim trace entries                     2,359,296        2,359,296    0.00
shared sql area                            255,896,520    1,354,739,608  429.41
shared table definiti                           13,160           17,792   35.20
shared Temporary Tables State Ob               621,936          621,936    0.00
shared trace buffer                            589,824        7,618,560 #######
shared transaction                           4,888,784        4,888,784    0.00
shared trigger defini                            2,128            1,552  -27.07
shared trigger inform                              792              664  -16.16
shared txncallback                             196,128           65,376  -66.67
shared UNDO INFO HASH                           93,088           93,088    0.00
shared UNDO INFO SEGMENTED ARRAY               518,792          518,792    0.00
shared 1M buffer                             1,056,768        1,056,768    0.00
       buffer_cache                     10,737,418,240   10,737,418,240    0.00
       fixed_sga                               764,896          764,896    0.00
       log_buffer                            2,622,464        2,622,464    0.00
          -------------------------------------------------------------
Resource Limit Stats for DB: HPRD1  Instance: HPRD1  End Snap: 46994
-> only rows with Current or Maximum Utilization > 80% of Limit are shown
-> ordered by resource name

                                 Current      Maximum     Initial
Resource Name                  Utilization  Utilization  Allocation      Limit
------------------------------ ------------ ------------ ---------- ----------
parallel_max_servers                      0            5          6          6
          -------------------------------------------------------------
init.ora Parameters for DB: HPRD1  Instance: HPRD1  Snaps: 46923 -46994

                                                                  End value
Parameter Name                Begin value                       (if different)
----------------------------- --------------------------------- --------------
background_dump_dest          /prod01/adm/admin/HPRD1/bdump
compatible                    9.2.0.0.0
_controlfile_enqueue_timeout  3600
control_files                 /prod01/u01/oradata/HPRD1/control
core_dump_dest                /prod01/adm/admin/HPRD1/cdump
cursor_sharing                EXACT
db_block_size                 8192
db_cache_advice               ON
db_cache_size                 10737418240
db_domain
db_file_multiblock_read_count 16
db_files                      400
db_name                       HPRD1
db_writer_processes           1
dml_locks                     500
event                         10499 trace name context forever,
fast_start_mttr_target        300
hash_area_size                13107200
hash_join_enabled             TRUE
instance_name                 HPRD1
java_pool_size                33554432
job_queue_processes           2
large_pool_size               16777216
log_archive_dest_1            LOCATION=/prod01/u07/oradata/HPRD
log_archive_dest_2            LOCATION=/prod01/u10/oradata/HPRD
log_archive_format            arch_%t_%s.dbf
log_archive_start             TRUE
log_buffer                    2359296
max_dump_file_size            5242880
open_cursors                  2000
optimizer_index_cost_adj      50
pga_aggregate_target          4294967296
processes                     2400
query_rewrite_enabled         FALSE
remote_login_passwordfile     EXCLUSIVE
resource_limit                TRUE
resource_manager_plan
sessions                      2645
sga_max_size                  17183267808
shared_pool_reserved_size     503316480
shared_pool_size              3355443200
sort_area_size                52428800
star_transformation_enabled   FALSE
timed_statistics              TRUE
undo_management               AUTO
undo_retention                10800
undo_tablespace               UNDOTBS1
user_dump_dest                /prod01/adm/admin/HPRD1/udump
utl_file_dir                  *
          -------------------------------------------------------------

End of Report

